Failed to convert parameter value from a String to a DateTime

Question

1.80/5 (2 votes)

See more:

In a page, I write the code:(for data insert in to Database)

C#

string Openingdate = tbopendate.Text;
myCommand.Parameters.Add("@Openingdate", System.Data.SqlDbType.DateTime).Value = Openingdate;

This code is working fine, there is no error.

But the same code I write in another page & the code is ((for data insert in to Database).

C#

string Joindate = tbJoindate.Text;
myCommand.Parameters.Add("@Joindate", System.Data.SqlDbType.DateTime).Value = Joindate;

This code is showing error::Failed to convert parameter value from a String to a DateTime.

Why & where is the problem???

Posted 10-Apr-13 1:22am

prodipjsr

Updated 11-Sep-18 6:54am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

PrashantSonewane 10-Apr-13 7:27am

can you try
DateTime dt = DateDateTime.Parse(tbJoindate.Text);

myCommand.Parameters.Add("@Joindate", System.Data.SqlDbType.DateTime).Value = dt;

prodipjsr 10-Apr-13 7:36am

I hv try but the system show the error::String was not recognized as a valid DateTime.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Apr-13 9:41am

What is the format and value you are getting in tbJoindate.Text ?
Please give some example.

prodipjsr 11-Apr-13 2:07am

dateFormat: 'mm-dd-yy',

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

Anuja Pawar Indore · Answer 1 · 2013-04-10T01:35:00

Solution 2

I don't know how you are not getting error in the first. Are both having datetime type in database? If yes then first one also should not work.
You have to convert text to datetime
Try this
[Edit]

C#

DateTime date = DateTime.ParseExact(tbJoindate.Text.ToString(),
                         "yyyy-MM-dd HH:mm:ss.fff",
                         CultureInfo.InvariantCulture);

cmd.Parameters.Add("@Joindate", SqlDbType.DateTime).Value = date;

Posted 10-Apr-13 1:35am

Anuja Pawar Indore

Updated 10-Apr-13 2:00am

v2

Comments

prodipjsr 10-Apr-13 7:38am

yes first one is working fine..And both data type is same DateTime...

prodipjsr 10-Apr-13 7:54am

can u give me the solution please..

Anuja Pawar Indore 10-Apr-13 8:00am

I have updated please try and see

prodipjsr 11-Apr-13 2:09am

not working

_Amy · Answer 2 · 2013-04-10T01:59:00

Solution 4

Try parsing the date. Let's check whether the given tbJoining date is a DATE or not. Try this:

C#

DateTime dt;
DateTime.TryParse(tbJoindate.Text.Trim(), out dt);
myCommand.Parameters.Add("@Joindate", System.Data.SqlDbType.DateTime).Value = dt;

--Amit

Posted 10-Apr-13 1:59am

_Amy

TrushnaK · Answer 3 · 2013-04-10T02:32:00

Solution 5

C#

DateTime date=Format(CDate(tbJoindate.Text),"yyyy-MM-dd")
mycommand.parameters.Add("@Joindate",date);

or

C#

DateTime date=DateSerial(Mid(tbJoindate.Text, 7, 4), Mid(tbJoindate.Text, 4, 2), Mid(tbJoindate.Text, 1, 2))
mycommand.parameters.Add("@Joindate",date);

Posted 10-Apr-13 2:32am

TrushnaK

Updated 10-Apr-13 3:25am

v2

Zafar Sultan · Answer 4 · 2013-04-10T04:03:00

As we don't have the sample dates you are using, I am assuming that the first portion of you code is working because the date you are passing is correct(unintentionally). For example, passing "10/10/2013" is a valid date both in "dd/MM/yyyy" format as well as "MM/dd/yyyy" format. The second part is not executing because passing "15/12/2013" is correct in "dd/MM/yyyy" format but it is incorrect in "MM/dd/yyyy" format. And maybe the culture of your application is "en-US". So there is an error in the dates you are passing. If the textboxes you are using takes dates in "MM/dd/yyyy" format, your code should work fine. But, if your textboxes are taking dates in "dd/MM/yyyy" format, you can convert it in "MM/dd/yyyy" format by using the below code:

C#

string InputDate = YourDateTextBoxId.Text.Trim();
System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo();
dateInfo.ShortDatePattern = "dd/MM/yyyy";
DateTime OutputDate = Convert.ToDateTime(InputDate, dateInfo);

OutputDate will be the valid date. Try it and tell us if it works.