Thousand Separator

[Tooraj]

Hi,
I want to show contents of GriView column with thousand separator, please write a sample code.
Thank you, Tooraj Azizi.

[Emanuel Varga]

Hello Tooraj,

In order to achieve this behavior you can register for the DataBindingComplete event, and enable the ThousandSeparator for the DecimalColumn.

void radGridView1_DataBindingComplete(object sender, GridViewBindingCompleteEventArgs e)
{
    var decimalColumn = radGridView1.Columns["DecimalColumn"] as GridViewDecimalColumn;
    decimalColumn.ThousandsSeparator = true;
}

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

[Rutuja]

Hi , I tried to use this code but its not working.

The column name is 'amount' and I added this code, please can you help me in this.

private void radGridView2_DataBindingComplete(object sender, GridViewBindingCompleteEventArgs e)
{

var decimalColumn = radGridView2.Columns["Amount"] as GridViewDecimalColumn;
decimalColumn.ThousandsSeparator = true;
}

[Dimitar]

Hello Rutuja,

Please note that this formats the value in the editor only. If you want it to be visible in the cells when not editing you need to set the format string:

var decimalColumn = radGridView1.Columns[0] as GridViewDecimalColumn;
decimalColumn.ThousandsSeparator = true;
decimalColumn.FormatString = "{0:n}";

I hope this will be useful. Let me know if you have additional questions.

Regards,
Dimitar
Progress Telerik