Loading

DataColumn.Expression & money

Guest User

How could I set the Expression property for formatting a money column. By default, money data type suppose 4 decimals... I want to display only 2. Thank you in advance.

2 Replies

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

dip_2004_0523y ago
The expression property should ideally be used for calculations. You can specify a formatting for the column using the DataFormatString property of the datacolumn as DataFormatString="{0:c}" or a format more suitable for your requirements. - dip
chrishornberger23y ago
It should follow the other standard formatting rules. Try something like "n2" Also look in the documentation on the int objects's "ToString(...)" overrides to see some usage of the NumberFormatInfo object (I think that's the name).