Database Server Mode Limitations

• Aug 01, 2019
• 2 minutes to read

In server mode, ASPxGridView does not have simultaneous access to bound data in its entirety. This imposes some limitations on the grid’s features, which are still available in regular binding mode. see the list below for information on features that are not supported in database server mode:

• filtering and sorting data by display text (not by edit values);
• search with search panel by display text;
• case-sensitive filtering; the grid converts a search string to lower-case before filtering;
• custom sorting (ASPxGridView.CustomColumnSort) and custom grouping (ASPxGridView.CustomColumnGroup);
• group modes specified by the GridViewDataColumnSettings.GroupInterval property (rows are always grouped by the values of grouping columns);
• calculating custom summaries using the ASPxGridBase.CustomSummaryCalculate event;
• calculating summaries for unbound columns whose values are provided using the ASPxGridView.CustomUnboundColumnData event. Summaries can still be calculated for unbound columns that are populated using expressions (see GridViewDataColumn.UnboundExpression);
• sorting, grouping, filtering and summary calculation for unbound columns whose values are provided using the ASPxGridView.CustomUnboundColumnData event; these features are still supported for unbound columns that are populated using expressions (see GridViewDataColumn.UnboundExpression);
• selection of all grid rows using the built-in SelectAll check box (when the GridViewCommandColumn.SelectAllCheckboxMode property is set to AllPages).