how to get rid of this error "conversion failed when converting datetime from character string"?

Question

3.00/5 (2 votes)

See more:

i put a datetimepicker on my form n named it as F_B1.
initialize a variable as below

string f_date = F_B1.Text;

and f_date value is going in a column whose datatype is datetime but i m getting this error

conversion failed when converting datetime from character string

Posted 17-Jun-11 21:41pm

Sweety Khan

Add a Solution

2 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)

OriginalGriff · Accepted Answer · 2011-06-17T21:50:00

Solution 2

Don't convert it to a string. Instead of using the Text property of the DateTimePicker, use the Value property - this is already a DateTime so no conversion is needed.
As a general rule, never convert unless you have to: work with DateTime values until you are actually outputting to a screen or printer - they are much more flexible, as well as being smaller!

Posted 17-Jun-11 21:50pm

OriginalGriff

Comments

Sweety Khan 18-Jun-11 3:58am

thanx a lot :) its done by coding this
DateTime f_date = F_B1.Value;

OriginalGriff 18-Jun-11 4:06am

You're welcome!

Sergey Alexandrovich Kryukov 18-Jun-11 19:08pm

Correct, a 5.
--SA

arathi_suresh · Accepted Answer · 2011-06-17T21:48:00

Solution 1

Did you use Convert.ToDateTime(f_date) ?

Posted 17-Jun-11 21:48pm

arathi_suresh

v2

Comments

Sweety Khan 18-Jun-11 3:57am

thanx u so much. u realized me tht there is a DateTime datatype in c# :)

arathi_suresh 18-Jun-11 3:59am

Welcome..Please mark as solution if it worked

Sweety Khan 18-Jun-11 11:28am

yes i marked it n also vote it