Conversion from type 'Date' to type 'Double' is not valid.

Question

0.00/5 (No votes)

See more:

am developing an application but am getting exception as conversion from type Date to Double is not valid.

VB

while (reader.Read())

                        myarrlst11_1.Add(reader("sno").ToString)    'sno

                        a = reader("Date")
                        b = reader("Time")
                        a = Convert.ToInt32(reader(Convert.ToInt32(a)))
                        b = Convert.ToInt32(reader(Convert.ToInt32(b)))
                        StrSql.Parameters.AddWithValue("@a", Convert.ToDouble(a))
                        StrSql.Parameters.AddWithValue("@b", Convert.ToDouble(b))

end while

plz help me with sample code or any idea why this exception is coming

Posted 2-Jul-12 0:00am

Member 8953292

Updated 2-Jul-12 0:03am

Mehdi Gholam

v2

Add a Solution

Comments

Shemeer NS 2-Jul-12 6:10am

can you explain what you are tring to acheive?

Member 8953292 2-Jul-12 6:16am

actually i want to take a excel sheet with data as input and using excel sheet values i want to draw a chart.am able to display that excel sheet but in that sheet i have date and time to display on chart so i am trying to do that but am getting many exceptions as above and input string not in a correct format and Unable to cast object of type 'System.DateTime' to type 'System.DateTime[]'.so i want u or any one can help me complete this application plz

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)

Sandeep Mewara · Answer 1 · 2012-07-02T00:33:00

VB

a = reader("Date")
b = reader("Time")
a = Convert.ToInt32(reader(Convert.ToInt32(a)))
b = Convert.ToInt32(reader(Convert.ToInt32(b)))
StrSql.Parameters.AddWithValue("@a", Convert.ToDouble(a))
StrSql.Parameters.AddWithValue("@b", Convert.ToDouble(b))

All throughout the above code, you are trying to convert extracted values of a & b

Based on the field names (& error you get), it looks like values of a & b are of DateTime type. Since the data extracted is of Date type, you get an error when you try to convert it into double.

Options:
1. Get the data in format you want.
2. change your strSql that expects double, pass dates to it and modify it to accept dates instead of double.