decimal format

[Adam The Generic]

Hi All,

I'm working on an asp.net report page that will allow the user to query some
data from a sql server database and output it on a GridVew object.
All returning data is decimal and has 4 scale.
Columns data types is Decimal(28,4) on sql server.

I am using "{0:#,0.0000}" string expression on ItemTemplate section of the
GridView object.

But the users want to see decimal values without a ineffective zero after
the decimal separator (in fraction part)
like that:

4145,1254 --> 4.145,1254
4012,1010 --> 4.012,101
712,7800 --> 712,78
44124,7000 --> 44.124,7
7104577,0000 --> 7.104.577

How can i support that ?

Thanks in advance...

 

[Peter Morris]

http://blog.stevex.net/index.php/string-formatting-in-csharp/

First hit when you Google for C# format strings

 

[Adam The Generic]

Thanks Peter,

I have seen that blog before, but there is no sample to get rid of all
ineffective zeroes ( trailing zeroes) on the fractional part.

All samples depend on the fixed number for fractional part.

for example, in 4145,7800, the last two zeroes are trailing zeroes, and i
need to get ride of them and find the 4.145,78
for 4145,7890 as another sample the last zero is a trailing zero i need
4.145,789

 

[Peter Morris]

It says to use # instead of 0

 

[Adam The Generic]

Yes Peter,

You are right.
My bad.

If i use # instead of 0, it removes all trailing zeros.
i try {0:#,####0.####}, and it works fine for now.

Thanks again..