format data in underlying table of GCC

[Wen Jiang]

I am using syncfusion 4.4.

What I want to do is the following.

DataTable dt = new DataTable();
GridGroupingControl gcc = new GridGroupingControl();
dt.Columns.Add("amount", typeof(double));

Now if I enter "3k" into dt from UI, I want the 3k is automatically changed to 3000. I know how to do the data conversion if I enter 3k into a textbox control, but don't know how to do this from a table.

Thanks for your help with this.

[Wen Jiang]

My problem is solved. Please ignore it. Thanks.

>I am using syncfusion 4.4.

What I want to do is the following.

DataTable dt = new DataTable();
GridGroupingControl gcc = new GridGroupingControl();
dt.Columns.Add("amount", typeof(double));

Now if I enter "3k" into dt from UI, I want the 3k is automatically changed to 3000. I know how to do the data conversion if I enter 3k into a textbox control, but don't know how to do this from a table.

Thanks for your help with this.