Regarding to taken date from textbox and store in database with date type after converting it

Question

0.00/5 (No votes)

See more:

Hi!

I want to know how to we can get a date value in text box and after converting string to date type store in database in date type.where DateTime.parse(textbox1.text)/DateTime.ParseExact(TextBox1.Text,"DD/MM/YYYYY:HH:MM:SS",null)does not working properly?

Posted 28-Aug-12 5:49am

Escortx

Add a Solution

Comments

[no name] 28-Aug-12 11:55am

Why is it that you think that DateTime.Parse "does not work properly"? It does work if you use it correctly. Use a DateTimePicker and you would not have to worry about converting.

ZurdoDev 28-Aug-12 11:55am

You can store any text that looks like a date in a SQL database date field so I am not sure what problem you are having.

Christian Graus 28-Aug-12 12:04pm

Storing dates as text is pure idiocy. He wants to store them as dates and is having trouble parsing them in to dates.

ZurdoDev 28-Aug-12 12:20pm

That isn't what I was saying. You can take anything from a textbox that looks like a date and store it in SQL as a date.

Christian Graus 30-Aug-12 12:07pm

So long as you first make sure it is a date, I agree.

1 solution

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)

Christian Graus · Answer 1 · 2012-08-28T06:04:00

Solution 1

They don't work because your text is not valid. Use DateTime.TryParse. You can specific, for example, the US format if you're in India and writing for the US. Then, if it fails, your string is not a valid date.

Of course you could use a date picker control, then your data will be a date to start with.

Posted 28-Aug-12 6:04am

Christian Graus

Updated 28-Aug-12 6:05am

v2