error in getting date in textbox

Question

0.00/5 (No votes)

See more:

I am using asp.net and c# with sql-server2005 database.

I am entering a date in textbox in format mm/dd/yyyy,yesterday it was working correctly but 2day i am getting error "String is not valid for datetime".

I am using this:

DateTime dt = DateTime.Parse(txtdob.Text);

and running query

SqlCommand cmd = new SqlCommand("insert into new_user values('" + ID + "','" + txtname.Text.Trim() + "','" + txtcompany.Text.Trim() + "','" + txtdesig.Text.Trim() + "',' " + txtcontact.Text.Trim() + " ','" + txtemail.Text.Trim() + "', '" + txtadd.Text.Trim() + "','" + dt + "')", con);

If you require anything else I can provide you.

The basic problem is I want to insert date like birthdate in textbox and want to save it in database.

Please help me, ~~its urgent~~....

Thanks

Posted 15-Sep-11 6:13am

Member 7861155

Updated 15-Sep-11 7:00am

Uwe Keim

v5

Add a Solution

Comments

Pradeep Shukla 15-Sep-11 13:02pm

I don't see any issue here, at which line you got this exception?

3 solutions

Solution 1

This is a bit of a long shot, but have you changed your locale settings recently? DateTime.Parse uses the system locale settings by default, so if you switched from a locale using mm/dd/yyyy to one using some other format (e.g. dd/mm/yyyy), then that could cause the error you're seeing.

P.S. you really should be using parameterized queries so as to avoid SQL injection!

Posted 15-Sep-11 7:03am

ekolis

Updated 15-Sep-11 11:48am

v2

Comments

RaviRanjanKr 15-Sep-11 17:49pm

Nice Answer, My 5+

Solution 2

the text in textbox was not in correct form.may be it is null or may be it is not in date time format

Posted 15-Sep-11 20:01pm

raj ch

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anele Ngqandu · Accepted Answer · 2011-09-15T21:18:00

Solution 3

Why dont you try to convert dt to a string

string newDate=Convert.ToString(dt);

then save as

SqlCommand cmd = new SqlCommand("insert into new_user values('" + ID + "','" + txtname.Text.Trim() + "','" + txtcompany.Text.Trim() + "','" + txtdesig.Text.Trim() + "',' " + txtcontact.Text.Trim() + " ','" + txtemail.Text.Trim() + "', '" + txtadd.Text.Trim() + "','" + newDate + "')", con);

Posted 15-Sep-11 21:18pm

Anele Ngqandu

Comments

Member 7861155 17-Sep-11 2:38am

I already did it, bt it is not working, it is showing error "String was not recognized as a valid DateTime".
Is there any other way to insert date. just tel me....
Thanks

Anele Ngqandu 17-Sep-11 3:09am

Sory sir why did you accept the solution if its not working?