How do I remove fraction after decimal

Question

0.00/5 (No votes)

See more: (untagged)

Hi,

I would like to remove fraction from my data table.

for example:

I have a following table:

A 98.581253
B 7.105125
C 101.325836

and I would like to show in datagridview in the following format:

A 98.58
B 7.11
C 101.32

Posted 1-Jun-15 19:04pm

Member 10704857

Add a Solution

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)

Ralf Meier · Accepted Answer · 2015-06-01T19:33:00

Solution 2

If you want a formatting of the values the you can use the method .toString("0.00")

Posted 1-Jun-15 19:33pm

Ralf Meier

Comments

Member 10704857 2-Jun-15 1:50am

how do it works?

please explain

Maciej Los 2-Jun-15 2:09am

Sorry, but this answer is wrong (my vote of 1). ToString() method does not round decimal values to the specified number of decimal places. It's a string representation of the decimal number with pre-defined number of decimal places.

Sergey Alexandrovich Kryukov 2-Jun-15 2:14am

You would be right, but only assuming that you would want to answer inquirer's question.
But answering this question is not the best help. Chances are, rounding is not needed, but formatting is exactly what is needed (even though rounding is hidden under the formatting).

How many cases you know when rounding is really needed? They are very rare. Moreover, rounding up is dangerous, because some calculations cause accumulation of rounding errors.

I'm going to vote 5 for this answer, which is the only one using some common sense, instead of just answering.

—SA

Maciej Los 2-Jun-15 2:19am

Ok, i looked at the question one more time. You're right, Sergey. OP wants to display data in DGV. Upvoted!

Ralf Meier 2-Jun-15 2:59am

Thank you Sergey
... and thank you too Maciej

Raul Iloc 2-Jun-15 2:27am

From the examples provided in the original question, you can see that he want Rounding at 2 decimals and not simple displaying first two decimals, see example B: 7.105125 ==> 7.11, so the 2nd solution is not OK for this!

Sergey Alexandrovich Kryukov 2-Jun-15 2:38am

When I hear "I want" or "he wants", I usually ask "why?" I have serious reasons not to trust it, in this particular case. Rounding is rarely really needed.
—SA

Raul Iloc 2-Jun-15 2:45am

When a request is made (especially from a customer), you should respect it.
And rounding at 2 decimals is used in financial reports/invoices for example.

Sergey Alexandrovich Kryukov 2-Jun-15 9:57am

Tell me about it.
Respect and and answering a question are different thing.
Giving exactly what a customer asked and misleading the customer in this way? No, thank you.

Frankly, this is what Ralf did not do: all the explanations I provided in response to your comment. The advice which is not a direct answer should be explained, motivated. But it should be given.

Now, about your argument: rounding for financial reports/invoice is exactly something which can be solved without rounding operation, but with formatting, exactly as shown in this answer. Did you realize it? It is still rounding, but without having a rounded numeric value, only the string. On output of all those reports/invoices, only the strings are used. This way, you only justified my point.

—SA

Raul Iloc · Accepted Answer · 2015-06-01T19:24:00

Solution 1

After reading the data from database, you should use Decimal.Round()- if you are using decimal values or Math.Round() for double values.

Posted 1-Jun-15 19:24pm

Raul Iloc

Updated 1-Jun-15 19:25pm

v2

Comments

Member 10704857 2-Jun-15 1:36am

I have tried this:

for (int x = 0; x < dtform.Rows.Count; x++)
{

decimal sub = decimal.Parse(dtform.Rows[x][3].ToString());

DGV1.Rows[x].Cells["A"].Value = Decimal.Round(sub);
}
the output is
A 99
B 7
C 101

I don't want this I would like set output with two decimal only

Raul Iloc 2-Jun-15 1:48am

You should use also the 2nd paramter of the Round method, with the value 2 (the number of decimals that you want to be kept)!

Maciej Los 2-Jun-15 2:05am

yes, +5!
https://msdn.microsoft.com/en-us/library/6be1edhb%28v=vs.110%29.aspx

Member 10704857 2-Jun-15 2:07am

Thanks for your guidance Raul.

Raul Iloc 2-Jun-15 2:18am

Welcome Maciej, I am glad that I could help you!

Maciej Los 2-Jun-15 2:21am

Sorry, i had to re-vote (3 stars - neutral). OP wants to display data, so he needs to use ToString() method. Please, see solution 2.

Raul Iloc 2-Jun-15 2:26am

From the examples provided in the original question, you can see that he want Rounding at 2c decimals and not simple displaying first two decimals, see example B: 7.105125 ==> 7.11, so the 2nd solution is not OK for this!

Member 10704857 · Accepted Answer · 2015-06-01T20:06:00

Solution 3

C#

for (int x = 0; x < dtform.Rows.Count; x++)
            {
                decimal sub = decimal.Parse(dtform.Rows[x][3].ToString());


                DGV1.Rows[x].Cells["A"].Value = decimal.Round(sub,2);
            }

Posted 1-Jun-15 20:06pm

Member 10704857

Updated 1-Jun-15 20:40pm

v2

Comments

CHill60 2-Jun-15 7:26am

After all of the effort the others went to just to help you, it is a bit rude to then answer your own question and even ruder to then formally accept it as the correct answer. Please don't do that in future.