Error while converting textbox content to DateTime format in C# ASP.net

Question

Hi i am developing an application, in that i required to store date in sql server 2005 database which is retrieved from a textbox in front end. In front end, user is allowed to pick a date from JQuery UI DatePicker plugin.

Error I am getting is as follows:

String was not recognized as a valid DateTime.

Code i have is:

db.eventDate = DateTime.Parse(txtDate.Text, new CultureInfo("en-US").DateTimeFormat);

be sure that the input is the correct format you are trying to convert to for the specified cultureinfo. what is the input format you are providing? — Ahmed ilyas
– Ahmed ilyas, Commented Apr 14, 2014 at 5:58
for ex: if i choose a date from the JQuery UI Datepicker, it would be like 14/04/2014 in textbox. I am trying to convert that textbox data (i.e., 14/04/2014) to a DateTime Format. — shary.sharath
– shary.sharath, Commented Apr 14, 2014 at 6:21
Right. this is exactly why it is not working - your format is a UK format. you need to give it the uk format so it can parse it to the correct datetime format in this case then convert it to a us format. however in the jquery ui picker I am sure you can set the default input type/format to be en-us which will then correctly set the format to a us format and then your parsing will work correctly. — Ahmed ilyas
– Ahmed ilyas, Commented Apr 14, 2014 at 6:35
while debugging the code i came to know that, textbox date is in format of 14/04/2014 and after converting it to a DateTime type it will remain like 1/1/0001 12:00 AM — shary.sharath
– shary.sharath, Commented Apr 14, 2014 at 6:36
yes because that is the default value when it cannot parse (I believe). like I said, do as I suggested — Ahmed ilyas
– Ahmed ilyas, Commented Apr 14, 2014 at 6:48

user1760979 · Accepted Answer · 2014-05-20 09:10:55Z

1

Try this code

string yourDate = txtDate.Text;
string formattedDate = yourDate.ToString("dd-MM-yyyy");
DateTime dt = DateTime.ParseExact(formattedDate , "dd-MM-yyyy", CultureInfo.InvariantCulture);

answered May 20, 2014 at 9:10

user1760979

Sign up to request clarification or add additional context in comments.

Comments

sh1rts · Accepted Answer · 2014-04-14 05:55:42Z

0

You should either use DateTime.TryParse(expression) or wrap your call to DateTime.Parse in a try/catch block. Just out of interest, can you post some example dates you're converting ? They are in US format, right ?

answered Apr 14, 2014 at 5:55

sh1rts

1,8841 gold badge13 silver badges14 bronze badges

2 Comments

Ahmed ilyas Over a year ago

Incorrect. having a try catch block around DateTime.TryParse will not throw an exception. TryParse does just that - tries to parse the given datetime value and returns true if success or false if not successful.

sh1rts Over a year ago

Please re-read what I wrote, I said "wrap your call to DateTime.Parse in a try/catch block", not DateTime.TryParse

Damith · Accepted Answer · 2014-04-14 05:57:21Z

0

you better use DateTime.ParseExact with the correct date time format you set to date time picker

for example if the format is "MM/dd/yyyy" you can do as below

db.eventDate =  DateTime.ParseExact(txtDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);

edited Apr 14, 2014 at 5:57

answered Apr 14, 2014 at 5:43

Damith

63.2k13 gold badges106 silver badges154 bronze badges

1 Comment

shary.sharath Over a year ago

Hi @Damith, I tried your code too. Now i am getting error like <prev><code>The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.</code></prev>

Jameem · Accepted Answer · 2014-04-14 06:37:12Z

0

Try this..Working fine for me..

Convert.ToDateTime(txtDate.Text,System.Globalization.CultureInfo.GetCultureInfo("en-US").DateTimeFormat);

or

Convert.ToDateTime(txtDate.Text);

edited Apr 14, 2014 at 6:37

answered Apr 14, 2014 at 5:44

Jameem

1,8383 gold badges15 silver badges26 bronze badges

2 Comments

shary.sharath Over a year ago

Hi Jameem, Thanks for your immediate response. I have tried your suggestion but still i am getting same error.

shary.sharath Over a year ago

In database it is 1/1/1900 12:00:00 AM by default. In my application user will pick date from JQuery UI date picker and it would be in the form 14/04/2014 and i am trying to convert this data from textbox to a valid DateTime type in code behind before inserting into database.

user3188781 · Accepted Answer · 2014-04-14 06:42:34Z

0

Hope following code helps you.

        Dim dt As New DateTime
        Dim txtDateFromUser As String = "04/09/2014"

        If DateTime.TryParse(txtDateFromUser, dt) = True Then

            Dim connStr As String
            connStr = System.Configuration.ConfigurationManager.ConnectionStrings("youConnectionStringName").ConnectionString

            'Insert into database
            Dim sqlconn As New SqlConnection
            sqlconn.ConnectionString = connStr
            Dim sqlcmd As New SqlCommand("insert into tblDateTime (dtTestDate) values ('" + dt.ToString() + "')")
            sqlconn.Open()
            sqlcmd.Connection = sqlconn
            sqlcmd.ExecuteNonQuery()

        End If

Here is the test table I've used:

        create table tblDateTime (dtTestDate datetime)

answered Apr 14, 2014 at 6:42

user3188781

2 Comments

shary.sharath Over a year ago

Nothing happened:( textbox date is getting converted to a default date 1/1/0001 12:00:00 AM I don't know how to come out of this error. And morething, in database it's data type is datetime only.

user3188781 Over a year ago

what is the date string you're getting from the textbox?

shary.sharath · Accepted Answer · 2014-04-16 09:26:14Z

0

i simply changed the date format of JQuery UI DatePicker in my code. Before it was in UK format so i was getting error while saving data to database. But once i change it to US format it working fine.

I thanks for everyone who reviewed my question and suggested me the answers.

answered Apr 16, 2014 at 9:26

shary.sharath

7292 gold badges15 silver badges32 bronze badges

Collectives™ on Stack Overflow

Error while converting textbox content to DateTime format in C# ASP.net

6 Answers 6

Comments

2 Comments

1 Comment

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

1 Comment

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related