FORMATTING A NUMBER IN A GRIDVIEW COLUMN

[Sarah]

Hi,
I would like to know,how should i go about formatting a decimal number in a column. I know DataFormatString="{}{0:c}" should be used in the XAML to format.But the problem is, my rad grid view loads data from different tables in the data base according to certain search paramters at run time, meaning dynamically.So unless the data is loaded i would not know which are the columns to be formatted.So I need help to know to fix the same.
Thanks,
Sarah

[Maya]

Hello Sarah,

You can set the DataFormatString property in the code-behind as follows:

(this.clubsGrid.Columns[2] as GridViewDataColumn).DataFormatString = "{0:C}";

Regards,
Maya
the Telerik team