Thursday, March 8, 2012

date format problem

hi..

can i change my date format of MS SQL 2000 to dd/mm/yyyypermanently as my user is more comfortable with this format.

i have made date textbox of datagrid readonly (enable=false) when i try to modify particular record from my datagrid, it shows me following error

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.

what should i do to overcome this error?

Use parameters of the datetime type, and make sure your asp.net application is running with a culture that has dd/mm/yyyy as a valid date time format.

No comments:

Post a Comment