saving decimal number

Question

Hi everyone I have this as Model: [code] [Required] public Decimal MondayHours { get; set; } [/code] and this in the view: [code] @Html.Label(Maandag) @string.Format({00:###:#} Model.Monday) @Html.TextBox(Monday Model.Monday.ToString() new{@readonly = readonly }) @Html.ValidationMessageFor(model=> model.Monday) [/code] but I put for example an number: 7.5 that the number will be saved as:7500. and not as: 75. THX for helping!!

Vulpes · Answer

Try changing this line: actualValue = Convert.ToDecimal(valueResult.AttemptedValue CultureInfo.CurrentCulture); to: actualValue = Convert.ToDecimal(valueResult.AttemptedValue CultureInfo.GetCultureInfo(en-US));

albert albert · Answer

THX Vulpes!!! So glad u helped me.

albert albert · Answer

but if I do this: 0075 then it will be saved as: 008. realy strange

albert albert · Answer

Even if I do this: 0.75. then it will be saved as: 7500

albert albert · Answer

I have it now like this: [code] @Html.Label(Maandag) @string.Format(new System.Globalization.CultureInfo(en-US) {0:0.##} Model.Monday) @Html.TextBox(Monday Model.Monday.ToString() new{@readonly = readonly }) @Html.ValidationMessageFor(model=> model.Monday) [/code] [code] Required] //[DisplayFormat(DataFormatString= {0:###0.000#})] public Decimal MondayHours { get; set; } [/code] And in global.asax.cs: [code] protected void Application_Start() { ModelBinders.Binders.Add(typeof(decimal) new DecimalModelBinder()); Database.SetInitializer (new TimeSheetInitializer()); AreaRegistration.RegisterAllAreas(); RegisterGlobalFilters(GlobalFilters.Filters); RegisterRoutes(RouteTable.Routes); } [/code] Because then I can save it like this: 7.5 instead of: 75. and then the class: [code] public class DecimalModelBinder:IModelBinder { public object BindModel(ControllerContext controllerContext ModelBindingContext bindingContext) { ValueProviderResult valueResult = bindingContext.ValueProvider .GetValue(bindingContext.ModelName); ModelState modelState = new ModelState { Value = valueResult }; object actualValue = null; try { actualValue = Convert.ToDecimal(valueResult.AttemptedValue CultureInfo.CurrentCulture); } catch (FormatException e) { modelState.Errors.Add(e); } bindingContext.ModelState.Add(bindingContext.ModelName modelState); return actualValue; } } [/code] but is still save as: 7500 instead of: 75

Vulpes · Answer

It might be a culture problem. I'd try: @string.Format(new System.Globalization.CultureInfo(en-US) {0:0.##} Model.Monday)

albert albert · Answer

I have it now like this: [code] @Html.Label(Maandag) @string.Format({0:0.##} Model.Monday) @Html.TextBox(Monday Model.Monday.ToString() new{@readonly = readonly }) @Html.ValidationMessageFor(model=> model.Monday) [/code] And when I create a new hour in the textbox standard value of this: 000. and then I change it to: 7.5 and press create. But then I see in the Index page that the value has changed to: 7500.

albert albert · Answer

I mean this: [code] @Html.Label(Maandag) @string.Format({0:0.##} Model.Monday) @Html.TextBox(Monday Model.Monday.ToString() new{@readonly = readonly }) @Html.ValidationMessageFor(model=> model.Monday) [/code]

albert albert · Answer

Hi Nattudurai  Thx for the replay. But it doesnt work :( I have it now like this: [code] [Required] //[DisplayFormat(DataFormatString= {0:###0.000#})] public Decimal MondayHours { get; set; } [/code] and for the view: [code] @Html.Label(Maandag) @string.Format({0:0.00} Model.Monday) @Html.TextBox(Monday Model.Monday.ToString() new{@readonly = readonly }) @Html.ValidationMessageFor(model=> model.Monday) [/code] And in the databse the property is a numeric. The value is still: 7500 instead of: 75 Sorry I mean this: [code] @Html.Label(Maandag) @string.Format({0:0.##} Model.Monday) @Html.TextBox(Monday Model.Monday.ToString() new{@readonly = readonly }) @Html.ValidationMessageFor(model=> model.Monday) [/code]

Nattudurai Eswaramurthy · Answer

use the below formatting @string.Format( {0:0.00}  Model.Monday) Hope this resolve ur problem