Failed to convert parameter value from a SqlParameter to DateTime

Question

0.00/5 (No votes)

See more:

Hi All,
my code is below: but i am getting error:"Failed to convert parameter value from a SqlParameter to DateTime".

Any suggestion plz will be appreciated.

SQL

DataTable dt = new DataTable();
        try
        {
            string spName = "spResult1";
            List<sqlparameter> paramlist=new List<sqlparameter>();
            
            paramlist.Add(new SqlParameter("@fromDate",obj.dateFrom));
            paramlist.Add(new SqlParameter("@toDate",obj.dateTo));

            DataSet ds = SqlHelper.ExecuteDataset(objconn._connectionString, spName, paramlist.ToArray());
            dt = ds.Tables[0];
           

        }
        catch(Exception ex)
        {
            MessageBox.Show(ex.Message.ToString());
        }
        return dt;</sqlparameter></sqlparameter>

Posted 11-May-12 3:47am

khosnur

Updated 11-May-12 4:34am

Maciej Los

v2

Add a Solution

Comments

Maciej Los 11-May-12 10:45am

You need to provide more details... like the body of stored procedure and the line in which error occurs.

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)

Rod Kemp · Answer 1 · 2012-05-11T04:21:00

There are two issues with your question;
1. obj.dateFrom and obj.dateTo, what do these return, a string or a DateTime object, if it returns a string the format can cause problems depending on the format dd/MM/yyyy vs MM/dd/yyyy you would be better off returning a DateTime instead of a string.
2. The SqlHelper class, how does this process DateTime objects?

In short when dealing with DateTime values either use an actual DateTime object as the parameter or if using a string use the dd MMM yyyy or yyyyMMdd formats so that you do not have to deal with ambiguous formats.

Wendelius · Answer 2 · 2012-05-11T06:25:00

Solution 2

If you have a look at the error, it says "Failed to convert parameter value from a SqlParameter to DateTime"

So somewhere you try to set a SqlParameter to a DateTime variable, not necessarily in the code you've posted.

If you debug, at what line the exception is thrown (remember to step into SqlHelper.ExecuteDataset when debugging)?

Posted 11-May-12 6:25am

Wendelius

Comments

khosnur 11-May-12 13:09pm

Thank u very much to reply..Mika.

Wendelius 11-May-12 14:00pm

You're welcome :)