Decimal (3,1) showing 2 Decimal Places!

Question

User-895481597 posted

Hi there,

I am reasonably new to C# and building ASP.NET Core so I hope this is an OK place to land this - I simply have set a field in my table to Decimal (3,1). It shows correctly to one decimal place in that table in SQL Server Management Studio and I even added a property :

[Column(TypeName = "decimal(3,1)")]

However when I load through ISS Express the field is setting to 2 decimal places. Does anybody know why?

Thanks, James

Answer 1

User753101303 posted

Hi,

This annotation only defines the SQL side column type.  You have also https://docs.microsoft.com/en-us/dotnet/api/system.componentmodel.dataannotations.displayformatattribute?view=netcore-3.1 that could work depending on how you are rendering currently this value.

Knowing how yoiu currrenly show this value could help to understand if it could work or to see which smallest change could fit your needs..

Answer 2

User-895481597 posted

Thanks, I eventually used:

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

Seemed to do the trick! Thanks for pointing me in the right direction!