Database Server Mode Limitations

• Dec 17, 2020

In server mode, ASPxVerticalGrid 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 (ASPxVerticalGrid.CustomRowSort);
• calculating custom summaries using the ASPxGridBase.CustomSummaryCalculate event;
• calculating summaries for unbound rows whose values are provided using the ASPxVerticalGrid.CustomUnboundRowData event; summaries can still be calculated for unbound rows that are populated using expressions (see VerticalGridDataRow.UnboundExpression);
• sorting, filtering and summary calculation for unbound rows whose values are provided using the ASPxVerticalGrid.CustomUnboundRowData event; these features are still supported for unbound rows that are populated using expressions (see VerticalGridDataRow.UnboundExpression);
• selection of all grid records using the built-in SelectAll check box (when the VerticalGridCommandRow.SelectAllCheckboxMode property is set to AllPages).