How to check my entered date is valid for SqlServer or not?

Question

0.00/5 (No votes)

See more:

Hello,

I have stuck with one issue.

I have a one textbox with calendar extender ,maskededit editor and mastededit validator ,which is could not valid for enter date 11/11/1111(MM/dd/yyyy) ,when this date pass to Sql server it is giving me SqlTypeException ,so in code behind i want to check the date is valid for Sql server or not before i pass it to Sql .

Any one has ideas about that???

Please help me out this???

Posted 16-Apr-13 1:56am

crazie.coder

Add a Solution

3 solutions

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)

tumbledDown2earth · Answer 1 · 2013-04-16T02:05:00

Solution 1

You can pass a DateTime to DbCommand/SqlCommand and keep in mind for Sql server the first valid date is 1/1/1973 as mentioned here[^]

Posted 16-Apr-13 2:05am

tumbledDown2earth

crazie.coder · Answer 2 · 2013-04-16T03:03:00

Solution 2

ya but i don't want to allow generate exception.i want to check it before i pass the date to sql.

by the way i got the solutions from below link

http://stackoverflow.com/questions/7054782/validate-datetime-before-inserting-it-into-sql-server-database[^]

Posted 16-Apr-13 3:03am

crazie.coder

José Amílcar Casimiro · Answer 3 · 2013-04-16T03:16:00

Hi,

The default date format in sql server is YYYY/MM/DD.
My recommendation is to use the command "set dateformat" before execute your query in sql server to specify the date format that you will insert or update the database.

To the year question see http://msdn.microsoft.com/en-us/library/bb677335.aspx[^]

Cheers,
JAFC