return decimal with two decimal places C#

Question

I'm trying to round decimal values with two decimal places, e.g. I have 57,328385899814471243042671610 and I want 57.33.

     for (int i = 1; i < cobtable.Columns.Count; i++) //loop para preencher a linha das percentagens
        {
            Decimal a = (Decimal)cobtable.Rows[2][i];
            Decimal b = (Decimal)cobtable.Rows[0][i];
            cobtable.Rows[3][i] = Decimal.Divide(a, b) * 100;

           // Decimal c = (Decimal)cobtable.Rows[3][i];

          // c = (a / b) * 100;

          //  c = Math.Round(c,2);

           Response.Write((Decimal)cobtable.Rows[3][i]);
           Response.Write("*");
        }

       GroupGrid.DataSource = cobtable;
       GroupGrid.DataBind();

the c variable gives me on response.write() the correct value but in the grid it doesn't show the same value, it shows 57,328385899814471243042671610. What am I doing wrong?

Why is the `Math.Round` line commented out? (although this doesn't set the value of the row) — Sayse, Jun 09 '15 at 10:23
`cobtable.Rows[3][i] = Math.Round(Decimal.Divide(a, b) * 100, 2);` — Steve, Jun 09 '15 at 10:29
Done! I used Steve's answer lol so easy.. Thank you all and thanks @Steve — Mara Pimentel, Jun 09 '15 at 10:31

score 0 · Answer 1 · answered Jun 09 '15 at 10:24

0

Use following method:

 Math.Round(57.328385899814471243042671610,2);

second parameter is no of decimal places

answered Jun 09 '15 at 10:24

M.S.

4,283
1
19
42

1

The OP already has, although commented it out. Suggesting that it didn't work for them as expected – Sayse Jun 09 '15 at 10:25
@Sayse You're overlooking the decimal in the answer. OP has a comma. – Sriram Sakthivel Jun 09 '15 at 10:31
@Sriram - The OP has a comma in the string, not in the double literal. – Wai Ha Lee Jun 09 '15 at 10:38
@WaiHaLee So the answer depends upon what culture OP is using. – Sriram Sakthivel Jun 09 '15 at 10:43

score 0 · Answer 2 · answered Jun 09 '15 at 10:33

0

System.Math.Ceiling(c * 100) / 100);

Something like this would probably work.

answered Jun 09 '15 at 10:33

Nicholas

783
2
7
25

Grant Winney · Answer 3 · 2015-06-09T10:40:53.020

0

Specify a DateFormatString for the column in question in your GridView.

DataFormatString="{0:F2}"  // Rounds to 2 decimal places

This affects how the value appears to the user, without causing actual data loss from rounding.

edited Jun 09 '15 at 10:40

answered Jun 09 '15 at 10:35

Grant Winney

65,241
13
115
165

I used this cobtable.Rows[3][i] = Math.Round(Decimal.Divide(a, b) * 100, 2); and gave me the values I want – Mara Pimentel Jun 09 '15 at 10:52

return decimal with two decimal places C#

3 Answers3