ASP.NET MVC data annotation for currency format

Question

I have following POCO with Cost as float.

public class CostChart
{
    public string itemType { get; set; }
    public float? Cost{ get; set; }

}

I need to return Cost in currency format e.g.

$U 4.882,50.

What data annotation should I use?

This is how I am displaying in my view.

<td>@Model.Cost</td>

It's way overdue, but please don't use ever `float`s for currency. They're not precise. Use a `decimal` instead. — Bart van Nierop, Oct 28 '16 at 08:17

score 59 · Accepted Answer · edited Feb 06 '19 at 04:19

59

Have you tried using DataType.Currency:

public class CostChart
{
    public string itemType { get; set; }
    [DataType(DataType.Currency)]
    public float? Cost{ get; set; }

}

Alternatively, you could use DataFormatString like this:

[DisplayFormat(DataFormatString = "{0:C0}")]`
public float? Cost{ get; set; }

But I prefer to set the display format with EditorFor. Here's a great tutorial on Extending Editor Templates for ASP.NET MVC tutorial.

That way, you write the display logic of your currencies in just ONE place, and you don't need to add that extract annotation every single time you want to display a currency amount.

--Edit

To make it work in EditorFor, you can also add ApplyFormatInEditMode = true to the end of the DataFormatString making the line as:

[DisplayFormat(DataFormatString = "{0:C0}", ApplyFormatInEditMode = true)]

edited Feb 06 '19 at 04:19

Raj Baral

641
6
19

answered Apr 30 '15 at 18:34

Cacho Santa

6,668
5
37
70

I tried above but it is not changing my value to currency on my view, it is still showing value without currency format. I am using this line on my view td>@Model.Cost – immirza Apr 30 '15 at 18:46
Try the editorfor template version in the tutorial. In that case, it should be @Html.EditorFor(m => m.Cost). – Cacho Santa Apr 30 '15 at 18:48
@HTML.EditorFor() just convert label into editable field with value showing 1233.44 and not in currency format. Am i missing some point here> – immirza Apr 30 '15 at 18:54
Sorry, it should have been @Html.DisplayFor( ), like in the tutorial. – Cacho Santa Apr 30 '15 at 18:55
2

decimal is a better datatype – niico Jan 28 '20 at 15:32
thanks @niico, I agree. I'd definitely go with decimal data type for this. – Cacho Santa Jan 28 '20 at 18:32

score 11 · Answer 2 · edited May 23 '17 at 12:34

11

Try using:

 [DisplayFormat(DataFormatString = "{0:C0}")]

Visit this post https://stackoverflow.com/a/19800496/3642086

edited May 23 '17 at 12:34

Community

1
1

answered Apr 30 '15 at 18:32

Márcio Gonzalez

992
1
7
19

score 7 · Answer 3 · answered Jan 20 '17 at 05:55

try this :

public class CostChart
  {
    public string itemType { get; set; }

    [DataType(DataType.Currency)]
    public float? Cost{ get; set; }
  }

if you still do not see $ symbol, in web.config under write this line of code

<globalization culture ="en-us"/>

score 2 · Answer 4 · answered May 29 '21 at 20:46

All right, when we talking about data annotations, there's two things to take in account:

The Data Annotation, which is:

[DisplayFormat(DataFormatString = "{0:C0}")]
public decimal? Cost{ get; set; }

And the tag in Razor pages, which is:

@Html.DisplayFor(model => model.Cost)

If you don't use "DisplayFor", data annotations is useless.

Another detail, if you want the decimal place, you should remove the last "0" after "C", as follow:

[DisplayFormat(DataFormatString = "{0:C}")]

Hope it helps you and good luck!

score 0 · Answer 5 · answered May 13 '19 at 11:52

0

You can do in RazorView

@string.Format("{0:0,0.00,00}", Model.Cost)

answered May 13 '19 at 11:52

venogn

56
6

score 0 · Answer 6 · answered May 31 '21 at 02:29

Try something like this if you want to show 4 digit decimal points (the number after C is showing the point number)

This works for float/decimal and double types:

[Display(Name="Price")] [DisplayFormat(DataFormatString = "{0:C4}")] public double Price { get; set; }

ASP.NET MVC data annotation for currency format

6 Answers6

Linked