How to truncate the decimal part in Asp.Net MVC3

Question

My application is in asp.Net MVC3 coded in C#.Net.

I want to truncate the decimal part of my values when they are displayed in the TextBoxes. The DataType for these values are set to Decimal in the database so even if i save 150 it saves as 150.0000.And when it displays a particular record it comes back as 150.0000 but i dont want it that way,i only want 150.

I have tried

  @Html.TextBoxFor(string.Format("Decimal Truncation Format", model => model.myValue))

But not working..The values are travelling from many views. So can i have such a truncation in the model itself so that it applied to that value all the time.

If not possible that way then how can i achieve it.?

Roy Dictus · Accepted Answer · 2012-01-31 12:49:54Z

2

Why don't you modify the property in your ViewModel to Int32? That should solve your problem in an instant!

EDIT:

This assumes that you have a ViewModel. You should never bind views directly to your db, but to a view-specific model (the ViewModel). Then you can modify that ViewModel as much as you want, so that it serves the needs of the View rather than those of the DB.

Check out the following links:

Good luck!

edited Jan 31, 2012 at 12:49

answered Jan 31, 2012 at 11:45

Roy Dictus

33.3k9 gold badges64 silver badges77 bronze badges

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

5 Comments

Sam M Over a year ago

thanks for the reply.But the phase in which my project is i cant afford to change the Database Definition,.

Roy Dictus Over a year ago

You don't have to change the DB definition, just the ViewModel.

Sam M Over a year ago

i have changed the Decimal To Int32 in the model.And i gets this error. The type 'Edm.Decimal' of the member 'MYValue' in the conceptual side type 'MyModel.MyClass' does not match with the type 'System.Int32' of the member 'MYValue' on the object side type 'MyApp.Models.MYClass'. And if i change it to Int32 lot Linq queries in my Application are throwing error.

Roy Dictus Over a year ago

Are you binding directly to your EDMX model?

Roy Dictus Over a year ago

Ah, that's the problem. You should never bind views directly to your db, but to a view-specific model (the ViewModel). Then you can modify that ViewModel as much as you want, so that it serves the needs of the View rather than those of the DB.

Softlion · Accepted Answer · 2012-01-31 14:03:10Z

0

Another solution: use TextBox instead of TextBoxFor, which let you initialize the field with any value.

@Html.TextBox("myValue",String.Format("{0}", Model.myValue)

answered Jan 31, 2012 at 14:03

Softlion

12.7k11 gold badges63 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to truncate the decimal part in Asp.Net MVC3

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related