Input string was not in correct format.

Question

0.00/5 (No votes)

See more:

hi,

currently I'm trying to convert string to int and the data I've retrieved from db.
Here is my code:

ant = int.parse(dr[1].tostring());

Please help me.I'm stuck with this bug!.

Posted 18-Aug-10 22:13pm

MissNano

Updated 18-Aug-10 23:36pm

Toli Cuturicu

v4

Add a Solution

Comments

Nuri Ismail 19-Aug-10 4:22am

You will have to elaborate on what the result string from "dr[1].tostring()" looks like? Is it something like "666" or "Ala Bala Bum" or...

Toli Cuturicu 19-Aug-10 5:35am

bad syntax, anyway; you should have:
ant = int.Parse(dr[1].ToString());

4 solutions

Solution 3

Int32.TryParse[^] might be what you are looking for: check the code examples given for usage.

Posted 18-Aug-10 23:43pm

R. Giskard Reventlov

Solution 1

MissNano

There may be two issues: (hope you have declared ant variable as int)

1. The data returned from the DB might be the Null value. hence error.

2. The data returned from the DB might not be the string value.

However, the String should contain the int value in string format.

Regards

Posted 18-Aug-10 22:31pm

shivaprasadk

Updated 19-Aug-10 0:11am

v3

Comments

Dalek Dave 19-Aug-10 4:33am

Seems reasonable.

Toli Cuturicu 19-Aug-10 5:38am

Reason for my vote of 1
Serious misunderstanding of the framework:
int.Parse returns an int, not a string!
Please, don't answer any more questions when you don't know what you are talking about.

shivaprasadk 19-Aug-10 6:09am

Toli Cuturicu: You are right as far as the ant variable type. It should be int.

Solution 4

hi
you will do the folling code

ant = Convert.ToInt32( dr["columnName"].ToString());
thanks

Posted 18-Aug-10 23:45pm

amin uddin cs

Comments

Arun Jacob 19-Aug-10 6:26am

Reason for my vote of 1
Wrong Answer. Even if you do like this,it'll throw error if dr["ColumnName"] is null, because ToString() doesn't handle null.

Toli Cuturicu 19-Aug-10 10:30am

Reason for my vote of 1
not quite so

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)

Toli Cuturicu · Accepted Answer · 2010-08-18T23:41:00

Solution 2

You should better use TryParse instead:

C#

int ant;
if (int.TryParse(dr[1], out ant)
{
    // everything ok
}
else
{
    // bad format -> take some corrective action!
}

Posted 18-Aug-10 23:41pm

Toli Cuturicu

Comments

Nuri Ismail 19-Aug-10 5:42am

Reason for my vote of 5
Good answer! :)