where condition is drpDate in sql 2005
I Found an error when the time of filling in grid.parameter passing as datetimein sql 2005.i dont know how to convert datetime to string and remaining parameters passing as string.give example with code... SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Ravi ShekharPosted Jul 17, 2013, 6:10 AM
check http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx
I am suggesting you to use 101 code .
Iftikar HussainPosted Jul 11, 2013, 11:20 AM
Please validate the input date before inserting into sql.
Regards,
Iftikar
Sunny SharmaPosted Jul 11, 2013, 7:09 AM
I assume you're doing so in C#.
Convert the DateTime value to string like this:
str dateStr = myDateTime.ToString("yyyy-MM-dd");
Hope it helps.
Cheers!