i am picking data from xml , but i want set numeric format so how i can do

Hi using Syncfusion.Grid.Grouping.Windows



i am picking data from xml , but i want set numeric format in grid .so how i can do...

Hi,

You can try this code snippet to set the numeric format to the column in a grid.

this.gridGroupingControl1.TableDescriptor.Columns["quantity"].Appearance.AnyRecordFieldCell.CellValueType = typeof(double);
this.gridGroupingControl1.TableDescriptor.Columns["quantity"].Appearance.AnyRecordFieldCell.Format = "P";

And also refer the TextFormat Browser Sample shows you how to format the data in your grid. You can see the code that formats numbers and dates. It also has code that does the validation on the cell values as you leave the cell. Essential Grid uses the .Net Framework formatting support so that there is no additional learning curve involved. As a result of the .Net Framework, the formatting is culture sensitive.

Here is a path
[install drive]\Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Windows\Samples\Appearance\TextFormat\

Best regards,
Haneef