input string in wrong format

Question

0.00/5 (No votes)

See more:

Hi All

I am getting the error input string not in correct format.

C#

Tusd = decimal.Parse(drTExp.GetValue(0).ToString());

Please can someone help me.

Thanks

Regards

Suman

Posted 14-May-14 1:58am

babli3

Updated 14-May-14 2:10am

CHill60

v2

Add a Solution

Comments

lukeer 14-May-14 8:03am

Obviously, drTExp is nothing that can be interpreted as decimal. What exactly is its value?

Prasad Avunoori 14-May-14 8:03am

May be it is other than Decimal.

Wessel Beulink 14-May-14 8:07am

what is Tusd for variable?

babli3 14-May-14 8:09am

it is decimal

CHill60 14-May-14 8:12am

What is the value of drTExp.GetValue(0) ?

babli3 14-May-14 8:13am

it is the value from the data reader

CHill60 14-May-14 8:17am

I gathered that much. I asked what the value is ... the contents, the results when you type ? drTExp.GetValue(0) into the Immediate window when debugging

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)

Pratik Bhuva · Accepted Answer · 2014-05-14T02:15:00

C#

Tusd = decimal.Parse(drTExp.GetValue(0).ToString());

Here You are getting this error because when compiler try to convert drTExp.GetValue(0).ToString() to decimal its getting wrong string format.
This happens when your string is empty or null or its not containing any decimal value.

Here you can avoid this by checking for the string before you do the conversation.And use Convert.ToString() instead of .ToString()

C#

Tusd =  !string.IsNullOrEmpty(Convert.ToString(drTExp.GetValue(0))) 
        ? 
        decimal.Parse(Convert.ToString(drTExp.GetValue(0))) 
        :
        0;