Format Exception throwing "Failed to convert parameter value from a String to a DateTime"

Question

0.00/5 (No votes)

See more:

Hi guys
I am facing some problem is when date time is not saved in DB .its thorws
Failed to convert parameter value from a String to a DateTime this exception

C#

SqlParameter LastLogIn = new SqlParameter("@LastLogIn", objUsers.LastLogIn);
                    LastLogIn.Direction = System.Data.ParameterDirection.Input;
                    LastLogIn.DbType = System.Data.DbType.DateTime;
                    sqlParams[5] = LastLogIn;

1.In DB datatype is also DateTime
2.button click event
objBusinessUI.LastLogIn = DateTime.Now;
current time i wanna show..but its throws exception

Please help

Thnxxxx in advance

Posted 10-Sep-13 23:07pm

indrajeet jadhav

Updated 11-Sep-13 1:45am

Dholakiya Ankit

v5

Add a Solution

Comments

Dholakiya Ankit 11-Sep-13 7:45am

you can use getdate() in sql..

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)

hunt for quest · Answer 1 · 2013-09-11T01:40:00

Hi Indrajeet,

What is the datetime value passed to the DB?
Even though the column is of Datetime type it may not accept all dateformats.

More over value from Dateteime.Now should be converted to string. This might the exception you are receiving not actual date insert issue.

Check this http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^] for more about Datetime.Now usage.

Also you can debug and check the value assigned to objBusinessUI.LastLogIn and then manually insert that value via SSMS and can trace the probelm easily.

indrajeet jadhav · Answer 2 · 2013-09-15T20:37:00

SqlParameter LastName = new SqlParameter("@LastName", objUsers.LastName);
LastName.Direction = System.Data.ParameterDirection.Input;
LastName.DbType = System.Data.DbType.String; //Actually i make mistake here.datatype i chhose ----------------------------------------------datetime instead of String thats y its throws exception
sqlParams[2] = LastName;

indrajeet jadhav · Answer 3 · 2013-09-15T20:38:00

Solution 3

I really thanxx appreciate the efforts who try to help me

Posted 15-Sep-13 20:38pm

indrajeet jadhav

manikjeyam · Answer 4 · 2013-09-16T19:34:00

Solution 4

Because datatable only stored date value
'MM/dd/yyyy' or yyyy/MM/dd' format only

DateTime.Now.ToString("MM/dd/yyy");
DateTime.Now.ToShortDateString();

Posted 16-Sep-13 19:34pm

manikjeyam

Format Exception throwing "Failed to convert parameter value from a String to a DateTime"

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0