stored procedures - Pass a date from datepicker to sql server database -
i have datepicker textbox below:
<input type="text" id="txtdob" class="datepicker" style="width:154px"/>
i not able pass value datepicker database table.everything works fine not going post entire code here.i passing value below:
cmd.parameters.addwithvalue("@dob", txtdob.value);
but says not find txtdob.any appreciated.
try this
cmd.parameters.add(new sqlparameter("@dob",data.sqldbtype.datetime)) cmd.parameters("@dob").value = txtdob.value;
Comments
Post a Comment