MVC model formatting decimal number

Question

in SQL server I have the field:

Price   decimal (12,4)

in MVC model:

public decimal? Price { get; set; }

When I add or edit price 1.1234 it will save 1.1200 in the database. I want to save it as it is 1.1234

score 0 · Answer 1 · edited May 23 '17 at 12:02

0

you need to add like this -

 dataItem.OtherFields["Price"].ToString("0.00000")

for more you can check out this

edited May 23 '17 at 12:02

Community

answered May 21 '17 at 07:13

tom

in view or in controller?? I did in Controller like this but not save also: item.Price = Convert.ToDecimal(itemViewModel.Price.ToString("0.0000")); – Ayman May 21 '17 at 07:27
in the models . – tom May 21 '17 at 07:30
In Model my code like this: @Html.TextBoxFor(model => model.Price, new { @class = "form-control" }) how i will format?? – Ayman May 21 '17 at 07:39
in view you can add like this- http://stackoverflow.com/questions/9721673/format-a-decimal-in-a-view – tom May 21 '17 at 07:44
i'm not reach :( – Ayman May 21 '17 at 08:01
I think Decimal will accept only 2 places or what?? have i to change to float?? – Ayman May 22 '17 at 05:20

1 Answers1