date time picker code lines

The date in the search string should compatible with the sql date column.( else typecast error )
Convert the date into sql suitable format(MM/DD/YY). User Convert.ToDateTime function.
(OR)
Else split the value from the date time picker using ,
int mon = date.Split(‘/’)[0].ToInt();
int day = date.Split(‘/’)[1].ToInt();
int yr = date.Split(‘/’)[2].ToInt();
and pass the string suitably.
Hope this helps!!!!!!

Is your data stored with time in the database or have you forced it to only have the date and 12:00:00. This determines if you need to use between in your select statement.

Now you need to format your datetime value to either have 12:00:00 as the time or create 2 values to be used in the between statement. This can be done in a number of way including string manipulation, data formatting or it can be done in the database if you are using stored procedures.