sum/add two textboxes

Question

1.00/5 (3 votes)

See more:

I have a little issue with adding values from two textboxes.

textbox 1 = gets value from sql (ex. 24.00 or 2.00 or 4.00,...)
textbox 2 = user enters value (ex. 24.00 or 2.00 or 4.00,...)

This is the error i get:

Input string was not in a correct format.

I have tried many different things, convert, decimal, tryparse, and i cant figuer out what i can do to fix this.

Please help.
Thank You.

UPDATE: fixed the values. Added "or" where i had ",".

C#

int totalAccwPrev = Convert.ToInt32(txtPrevRecd.Text) + Convert.ToInt32(txtAQty.Text);
int qtyOrd = Convert.ToInt32(txtQtyOrd.Text);

if (totalAccwPrev > qtyOrd)
{
    if (ddRCodeList.SelectedValue == "")
    {
        ShowPopUpMsg("Please select appropriate Rejected Code.");
        return;
    }
}

Posted 9-Dec-15 4:04am

r00n3y

Updated 9-Dec-15 4:53am

v4

Add a Solution

Comments

Anisuzzaman Sumon 9-Dec-15 10:08am

Please show your code

r00n3y 9-Dec-15 10:54am

added the code.

Sergey Alexandrovich Kryukov 9-Dec-15 10:14am

If your input string cannot be parsed as some numeric data, it cannot be used for your arithmetic. What may possibly need help here?
—SA

F-ES Sitecore 9-Dec-15 10:18am

You're going to have to post the code and also clarify exactly what is in your text boxes. Eg is it

24.00

or it could maybe be

2.00

or do you mean it is literally

24.00,2.00,4.00

Anyway, assuming it is a single value like 2.00 and assuming you are using TryParse, if you're getting errors it is probably to do with globalisation. 2.00 will only convert to 2 when using cultures that use a period as a decimal separator. So maybe you need to explicitly state the culture you want your TryParse to use (it's one of the parameters).

r00n3y 9-Dec-15 10:54am

updated the question.

F-ES Sitecore 9-Dec-15 10:57am

When you try and convert "24.00 or 2.00 or 4.00" to an int, what are you expecting as the output?

r00n3y 9-Dec-15 11:11am

I am only converting it to do math.

ZurdoDev 9-Dec-15 10:23am

The error should be very clear. The string is not in the correct format for whatever you are trying to do. Since we can't see your code, we can't help beyond that.

3 solutions

Solution 2

Hello..

Try to first convert textboxes value into decimal then into integer...

C#

int totalAccwPrev = Convert.ToInt32(Convert.ToDecimal("5.00") + Convert.ToDecimal("2.00"));
           int qtyOrd = Convert.ToInt32(Convert.ToDecimal("4.00"));

convert to integer get only integer part from the decimal i.r value before '.'

Hope this helps.
Thanks

Posted 9-Dec-15 18:38pm

Member 11027181

Solution 3

C#

textBox3.Text = (Convert.ToInt32(textBox1.Text) + Convert.ToInt32(textBox2.Text).ToString());

Posted 9-Dec-15 22:22pm

Kumarsamy

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)

OriginalGriff · Accepted Answer · 2015-12-09T04:28:00

If your database is returning values which are literally

C#

24.00,2.00,4.00

Then you have multiple values, and you can't store those in a single variable -= you need a separate one for each number in the sequence.
One way to handle this is to use Split:

C#

string s1 = "24.00,2.00,4.00";
string s2 = "14.00,12.00,8.00";
string[] parts1 = s1.Split(',');
string[] parts2 = s2.Split(',');
for (int i = 0; i < Math.Min(parts1.Length, parts2.Length); i++)
    {
    float f1, f2;
    if (float.TryParse(parts1[i], out f1) && float.TryParse(parts2[i], out f2))
        {
        Console.WriteLine("{0} + {1} = {2}", f1, f2, f1 + f2);
        }
    }

But you need to look at your DB and change it to not store comma separated values!