GCC numbers format and display

Question

I am using syncfusion 4.4.I use a dataTable as the dataSource of Gcc, the dataTable has a column of double type. I want Gcc displays the numbers in a well formatted way like 1,000,000. At the same time, I want the Gcc can sort this column based on numbers rather than strings. Any sample code will be appreciated.Millions of thanks!

Wen Jiang · Answer

My problem is solved, and I would like to share my solution here:

this.Gcc.TableDescriptor.Columns["ColNumber"].Appearance.AnyCell.Format = "#,###0.00";

>I am using syncfusion 4.4.

I use a dataTable as the dataSource of Gcc, the dataTable has a column of double type. I want Gcc displays the numbers in a well formatted way like 1,000,000. At the same time, I want the Gcc can sort this column based on numbers rather than strings. Any sample code will be appreciated.

Millions of thanks!