DataColumn.Expression & money

Question

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.

dip_2004_05 · Answer

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

chrishornberger · Answer

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).