Dates in FilterExpression of Sqldsource
I got a datepicker(EWS DatePicker its a 3rd party datepicker).If i select a date into that i need to display all the records in a gridview corresponding to that date.I am trying to give it in a filterExpression.
string mydate=datepick.txtDate.toshortdateString();
SqlDataSource1.filterexpression="Exp_Date LIKE '% ??????.
How can we use dates in filterexpression of a SQLDATASOURCE.
Thank you,
AMR.
|