Loading

Decimal Point

vijay antony

17y3.4k.NET

Hi Every One
i developed web Based application in ASP.Net
there i set one field as decimal data type(18,6)
so, where ever i receive this value it shows 0.000000

but i want to display any value for this field means
it shows all 6 digits
for example 0.6 means it shows 0.600000

for this operation i am not able to get the exact output

can anyone give the solution for this

regards
vijay

2 Replies

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

Kirtan Patel17y ago
Use Datatype

decimal(8, 6)

It Will Get the Result you want

Happy Coding :)
Roei Bar17y ago
hey there, Decimal has a ToString() Override that receives multiple Overrides for Formating, you can either set them by yourself Using "###,###.###" will set it to split on every 3 number by "," and display 3 spaces after the "." there are also the defaults that came with .NET like "N2" this will set the string 100000.0000000 to to 100,000.00 it shows 2 spaces after the "." here is the url for full spec and options in the msdn site: http://msdn.microsoft.com/en-us/library/fzeeb5cd.aspx