how to math round real data get in asp.net lable

Question

0.00/5 (No votes)

See more:

I am using This Calculation.I want to get Total in two decimal point in my Label.This code answers without decimal point. how to solve this Problem.anyone can help me.

C#

//get sum of value

    Decimal summ = 0;
    for (int n = 0; n < Cusinvoicegrid0.Rows.Count; ++n)
            {
                 summ += Convert.ToDecimal(Cusinvoicegrid0.Rows[n].Cells[3].Text);
            }
                       

          Decimal tott = Math.Round(summ,2);
          Label3.Text = tott.ToString();

Posted 21-Nov-13 18:40pm

Hasitha Wijesooriya

Updated 21-Nov-13 19:31pm

walterhevedeich

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Nov-13 1:19am

Can you debug and check what is the value of tott?

[no name] 22-Nov-13 1:24am

yes,it's without Decimal point answer.i Change Decimal tott into Double tott same answer

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Nov-13 1:32am

What is the value of summ after the loop?

[no name] 22-Nov-13 1:40am

decimal point value

3 solutions

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)

Rahul_Pandit · Answer 1 · 2013-11-21T19:42:00

Solution 1

C#

Decimal summ = 0;
for (int n = 0; n < Cusinvoicegrid0.Rows.Count; ++n)
{
     summ += Convert.ToDecimal(Cusinvoicegrid0.Rows[n].Cells[3].Text);
}
          summ =Convert.ToDecimal(summ.ToString("#,##0.00;-$#,##0.00;0.0"));
Label3.Text = summ;
let me know it works r not

Posted 21-Nov-13 19:42pm

Rahul_Pandit

Updated 21-Nov-13 20:16pm

v4

Comments

Rahul_Pandit 22-Nov-13 1:55am

it it working or not?

[no name] 22-Nov-13 2:01am

i try dear getting same error.Input string was not in a correct format.

[no name] 22-Nov-13 2:17am

http://msdn.microsoft.com/en-us/library/0c899ak8%28v=vs.110%29.aspx

Rahul_Pandit 22-Nov-13 2:19am

now it works or not

Rahul_Pandit 22-Nov-13 2:19am

check updated solution

[no name] 22-Nov-13 2:21am

//get sum of fuel
Double sum = 0;
for (int j = 0; j < Cusinvoicegrid0.Rows.Count; ++j)
{
sum += Convert.ToDouble(Cusinvoicegrid0.Rows[j].Cells[6].Text);
}

Double tot = Math.Round(sum, 2);
Label2.Text = tot.ToString("00.00",System.Globalization.CultureInfo.CreateSpecificCulture("da-DK"));

getting this error Input string was not in a correct format.

Rahul_Pandit 22-Nov-13 2:22am

Collapse | Copy Code

Decimal summ = 0;
for (int n = 0; n < Cusinvoicegrid0.Rows.Count; ++n)
{
summ += Convert.ToDecimal(Cusinvoicegrid0.Rows[n].Cells[3].Text);
}
summ =Convert.ToDecimal(summ.ToString("#,##0.00;-$#,##0.00;0.0"));
Label3.Text = summ;
let me know it works r not

did u try this?

[no name] 22-Nov-13 2:29am

i try not working

[no name] 22-Nov-13 2:34am

i think this one is error .this is my databind method to grid.gridview colum value without decimel point.how to slove this one.

Double SR = Math.Round((Double.Parse(Cusinvoicegrid.Rows[i].Cells[4].Text)) * (surcharge/ 100), 2);
dr["Fuel"] = SR ;
dt1.Rows.Add(dr);
Cusinvoicegrid0.DataSource = dt1;
Cusinvoicegrid0.DataBind();

Sergey Alexandrovich Kryukov · Answer 2 · 2013-11-21T20:35:00

You don't really need rounding. Rounding is rarely needed and can even be considered dangerous as you may accidentally loose precision if some rounding gets into intermediate results of calculation.

Instead, you just need string formatting of numeric data with proper formatting:
http://msdn.microsoft.com/en-us/library/fzeeb5cd(v=vs.110).aspx[^],
http://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.110).aspx[^],
http://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.110).aspx[^].

—SA

King Fisher · Answer 3 · 2013-11-21T20:50:00

Solution 3

using System.Globalization;

System.Globalization.CultureInfo culInfo = new System.Globalization.CultureInfo("hi-IN");

lbltotal.Text = total.ToString("C", culInfo).Remove(0, 2).Trim();

Posted 21-Nov-13 20:50pm

King Fisher