asp.net C# decimal formatting money

Question

I have a decimal value stored db as "12.3456" I want it to show it to client as "12.34"

I am using the code below .

<%# DataBinder.Eval(Container.DataItem, "Price", "{0:c}")%>

I want the format to be like this

12.3456 --> 12.34

but it's giving me this instead.

12.3456 --> 12.3500

I am not sure if I am missing something or did something wrong.

UPDATE

I end up doing with asp:Label instead of <%# DataBinder.Eval(Container.DataItem, "Price", "{0:c}")%>

Label Price.Text = Math.Truncate(12.3456* 100) / 100).ToString();

which gives me:

12.34

but if the number is 12.1000 it's giving me:

12.1

I need it in the 12.10 format

i need revers of this question , in model it's public decimal amount{get;set;} but when i enter value (29.0987) i get 30 or 0.1234 i get 0.12 but i need to have exact values it's possible — SAR
– SAR, Commented Dec 12, 2016 at 12:03

Cœur · Accepted Answer · 2019-12-15 11:34:13Z

1

Use a format string of #.00 to always show to 2 decimal places.

Label price.Text = String.Format("{0:#.00}", 12.1000)

https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings

edited Dec 15, 2019 at 11:34

Cœur

39k25 gold badges207 silver badges282 bronze badges

answered Oct 12, 2013 at 10:02

Simon Halsey

5,4941 gold badge23 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user2873685 Over a year ago

this is also giving me 12.3500 i need 12.34

Simon Halsey Over a year ago

Are you sure, because Console.WriteLine("{0:#.00}", 12.3456); is displayed as 12.35. Are trying to round down, ie 12.34 instead of 12.35?

user2873685 Over a year ago

<%# DataBinder.Eval(Container.DataItem, "Price", "{0:#.00}")%> this is what i have in repeater right and i have 12.3456 in db. It's giving me 12.3500 on the page.

Simon Halsey Over a year ago

Something else must be modifying your output then. This is taken from above link on formatting. 0.45678 ("0.00", en-US) -> 0.46

user2873685 Over a year ago

Solved it by adding label control inside repeater Label price.Text = String.Format("{0:#.00}", 12.1000) --> 12,10

Rahul Tripathi · Accepted Answer · 2013-10-12 10:43:30Z

0

You can try like this:-

 <%# DataBinder.Eval(Container.DataItem, "Price", "{#.00}")%>

EDIT:-

I think you need the values without rounding it. You may try like this:-

var f = 12.3456;
f = Math.Truncate(f * 100) / 100;

edited Oct 12, 2013 at 10:43

answered Oct 12, 2013 at 10:03

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

4 Comments

Anirudha Over a year ago

This would round .3456 to .35

user2873685 Over a year ago

this is giving me 12.3500 i need 12.34

user2873685 Over a year ago

Since i am binding a list of items as they are in code behind. I would do a foreach loop as a last resort. I would like to solve this in <% %> tags because i have lots of pages like this so i could apply this easily in all of them.

user2873685 Over a year ago

i end up doing a foreach loop in the end

bensiu · Accepted Answer · 2013-10-12 11:37:21Z

0

You can use

Math.Floor(12.3456*100) / 100 ;

edited Oct 12, 2013 at 11:37

bensiu

25.7k56 gold badges81 silver badges117 bronze badges

answered Oct 12, 2013 at 11:05

Dev

1,5711 gold badge22 silver badges35 bronze badges

Comments

Ben Steinwand · Accepted Answer · 2016-01-26 19:07:18Z

0

.toString(C) 'C' is for Currency.

answered Jan 26, 2016 at 19:07

Ben Steinwand

213 bronze badges

Collectives™ on Stack Overflow

asp.net C# decimal formatting money

4 Answers 4

5 Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related