Expression columns in gridGroupingControl

[Prathima Venkobachar]

Hi ,

We have a background dataTable which contains expression columns.

For eg.,

DataColumn col1 = new DataColumn();

col1.Expression = col1 – col2;

This.dataTable.Columns.Add(col1);

We then bind this table to the grid. We can’t use the facility present in the grid for creating expression fields as we have other constraints.

The problem is whenever we have such columns the grid takes a lot of time to come up otherwise its quite faster.

Are there any means to improve the performance?

Thanks,
Prathima

[Administrator]

I suspect the slowdown is related to the DataColumn.Expression, and does not have anything to do with the GridGroupingControl as the grid treats the expression column just like any other column in the datatable.

One thing you can try is to use an unbound column in the GridGroupingControl instead of a Expression column in the DataTable. Then in the QueryValue event, you can set the calculated value there using the passed in record. Take a look at this sample. It shows how to add a unbound field.

Syncfusion\Essential Suite\3.3.0.0\Windows\Grid.Windows\Samples\Grouping\EmployeeTerritoryOrder