inserting in dd/MM/yyyy format...
but if i select gridrow tat date is displayed in my textbox ... now if i select some other date t date format comes like 5/31/2012.
so while updating that date value it shows error as
String was not recognized as a valid DateTime..
Any suggestion Please i m using sql2008 with Datatype Date
Kunal VaishyaPosted May 19, 2012, 2:44 AM
sql server cant save date dd/MM/yyyy you should save like this MM/dd/yyyy