saving decimal number

albert albert

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:75,00. and not as: 7,5.

THX for helping!!

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
Try changing this line:

actualValue = Convert.ToDecimal(valueResult.AttemptedValue, CultureInfo.CurrentCulture);

to:

actualValue = Convert.ToDecimal(valueResult.AttemptedValue, CultureInfo.GetCultureInfo("en-US"));
albert albert14y ago
THX Vulpes!!!

So glad u helped me.
albert albert14y ago
but if I do this: 0,075 then it will be saved as: 0,08. realy strange
albert albert14y ago
Even if I do this: 0.75. then it will be saved as: 75,00
albert albert14y ago
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: 7,5.

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: 75,00 instead of: 7,5
Vulpes14y ago
It might be a culture problem.

I'd try:

@string.Format(new System.Globalization.CultureInfo("en-US"), "{0:0.##}", Model.Monday)
albert albert14y ago
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: 0,00. 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: 75,00.
albert albert14y ago
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 albert14y ago
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: 75,00 instead of: 7,5

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 Eswaramurthy14y ago
use the below formatting
```
  @string.Format("{0:0.00}", Model.Monday)

Hope this resolve ur problem
```