Error message while using datetime picker

Question

0.00/5 (No votes)

See more:

Hello,

I developed a small windows form application with a datetime picker. When i click a button, the date from datetime picker gets stored to sql database. But dates from 01/02/2012 till 12/02/2012 gets stored. But, when 13/02/2012 is entered an error is shown
"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value".

Posted 1-Feb-12 3:03am

gokulkmp

Updated 1-Feb-12 3:15am

lukeer

v2

Add a Solution

Comments

ZurdoDev 1-Feb-12 9:08am

What language is the SQL db. If english and american collation 13/02/2012 is invalid because the first number is a month. Sounds like that is what is happening.

gokulkmp 1-Feb-12 9:47am

When i changed the system date format, the dates got saved.

2 solutions

Solution 2

Don't convert the DateTime to a string, like you are doing at the moment. Use a Parametrized query, and pass the DateTime directly. That way, you do not have to worry about localised date format (currently dd/MM/yyyy on your PC) versus ISO (yyyy-MM-dd) on SQL Server

C#

SqlCommand cmd = new SqlCommand("INSERT INTO myTable (dateColumn) VALUES (@DT)", con);
cmd.Parameters.AddWithValue("@DT", myDateTimePicker.Value);

Posted 1-Feb-12 3:15am

OriginalGriff

Comments

gokulkmp 1-Feb-12 9:48am

Thank you, I will try this.

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)

Abhinav S · Accepted Answer · 2012-02-01T03:13:00

Solution 1

You need to check your date time format (could be based on your or the server's regional settings).
Dates from 01 to 12 may be getting stored incorrect as well. Month is getting stored as the first two characters and not the middle ones as would be expected.

Posted 1-Feb-12 3:13am

Abhinav S

Comments

gokulkmp 1-Feb-12 9:49am

When i changed the system date format, all dates got saved to database.