Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

c#

sql

sql-server

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); 
like image 590
Abdul Khaliq Avatar asked Apr 25 '14 07:04

Abdul Khaliq


1 Answers

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.

like image 187
Sudhakar Tillapudi Avatar answered Sep 22 '22 06:09

Sudhakar Tillapudi