In C# can we strore Decimal value with precison as 2 zeros after decimal point.

Question

1.00/5 (1 vote)

See more:

Hi All,

We are creating XML file through C# code with the help of XSD.

Here one field is decimal and field format is XXXX.XX(9999.00)

Now if digits after decimal is other than zero then we are able to achieve this but if a value is zero then it's getting rounded.

e.g:- if a value is 9999.96 then we are able to store correctly if but value is 9999.00 then its getting converted to 9999

Is it possible to store as 9999.00

Please provide me suggestions.

Thanks

Posted 5-Jan-15 8:03am

bhausahebshedbale

Add a Solution

Comments

ZurdoDev 5-Jan-15 14:05pm

Please click on improve question and show the code you're using to store the values.

Suvendu Shekhar Giri 5-Jan-15 14:24pm

But you can always format the value while showing somewhere using string.Format("{0:0.00}", value) or string.Format("{0:f2}", value) etc.

3 solutions

Solution 2

Any numeric value can be converted to a formatted string with ToString("format here") and in your case it would be ToString("#.00").

Posted 5-Jan-15 8:23am

Mehdi Gholam

Solution 3

Hi Thanks for Reply ... but I don't want to convert same in String.. need to maintain in decimal only. So coverting to String will not help me as field type in XSD is decimal.

Posted 5-Jan-15 8:42am

bhausahebshedbale

Comments

Kornfeld Eliyahu Peter 5-Jan-15 14:54pm

0. Learn to distinguish between number and its representation...
1. Do not post your comments as answers...
2. Learn XSD...

Sergey Alexandrovich Kryukov 5-Jan-15 15:21pm

Facepalm....
—SA

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)

Kornfeld Eliyahu Peter · Accepted Answer · 2015-01-05T08:22:00

In .NET (C#) decimal is a 128 bit numeric data type. The type itself, like with all the other types not defines how much significant digits you may or may not have after the decimal point...
First you must understand that here is no numerical (mathematical) difference between 999 and 999.00, so there should not be any problem receiving one or the another...However if you talking about a formatting for display purposes, than you should format the output...

C#

value.ToString("F2");

Where F means, fixed point, and 2 is the number of digits after the decimal point...
http://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.110).aspx[^]