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

c#, sql, sql-server

Solution

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

Solution : You need to use `dd/MM/yyyy` format.

Try This:

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

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

The month `April` does not have `31` days. It has 30 days. So you need to make sure you enter a valid date.

Problem

I 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); ```

Original source