CODEWITHSUNDEEP
c#databaseoledbdatareader
Abeer Islam
Abeer Islam

Reputation: 33

Input String not in correct format (Format Exception not handled)

I am trying to parse the retried value from the database into double, long, or integer, but it throws a FormatException. I need your help.

In this code, I am trying to retrieve hours from the database and sum them to calculate total hours input into the database.

String hrs;
Double resultHrs=0;

while (oleDbDataReader1.Read())
{
    hrs = oleDbDataReader1["Hours"].ToString();
    double HRS = double.Parse(oleDbDataReader1["Hours"].ToString());
    resultHrs = resultHrs + HRS;
}// end while

Upvotes: 0

Views: 318

Answers (2)

Kzest
Kzest

Reputation: 536

I use: 

 HRS = oledbDataReader1.GetDouble(iColumn);

where iColumn is the column index in the query

Upvotes: 1

Jon Skeet
Jon Skeet

Reputation: 1499770

Don't do the string conversion in the first place:

double hours = (double) oleDbDataReader1["Hours"];

Unless your value is actually a string in the database (in which case you should fix that) there's no reason to convert it into a string. (If it's not a type mapped to double, you should change what you cast it to, of course.)

EDIT: If it's non-numeric in the database, then you probably do need to use double.Parse - but you might want to specify the culture. For example, assuming they're all of the form "10.2" rather than "10,2" (as some cultures would use) you would want something like:

double hours = double.Parse((string) oleDbDataReader1["Hours"],
                            CultureInfo.InvariantCulture);

Upvotes: 2

Related Questions