Ayaat Shifa Ayaat Shifa - 4 months ago 102
SQL Question

The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar

enter image description hereI simply want to save Date of Birth into SQL database, but every time getting new exception, database field type is datetime.
here is my code

usinfo.BirthDate = DateTime.ParseExact(txtDOB.Text.ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture);

Answer

Problem : You are parsing the Month first using MM/dd/yyyy, but you are giving date first like this 31/04/2012

Soluton : You need to use dd/MM/yyyy format.

Try This:

usinfo.BirthDate = DateTime.ParseExact(txtDOB.Text.ToString(), "dd/MM/yyyy", 
                                                CultureInfo.InvariantCulture);

EDIT: You enetered an invalid Date here 31/04/2012.

April Month can not have 31 days.it can have maximum 30 Days. so you need to enter the Valid Date.

Comments