[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Collapse]Binding to Data
     Binding to Data Overview
     Binding to ICollectionView
    [Collapse]Server Mode
      Server Mode Overview
      Entity Framework 4.0+ Server Mode
      LINQ Server Mode
      Binding to In-Memory Data Using PLINQ
      Server Mode Limitations
      Instant Feedback UI Mode
    [Expand]Binding to any Data Source with Virtual Sources
    [Expand]TreeListView Data Binding
     Applying Data Annotations
     Unbound Columns
     Posting Data to a Connected Database
     Managing Multi-Thread Data Updates
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Selection
   [Expand]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus and Navigation
   [Expand]Conditional Formatting
   [Expand]Drag-and-Drop
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Server Mode Limitations

In server mode, the GridControl 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. This topic lists the Server and InstantFeedback Modes limitations.

Expanded Data Editing

Adding/deleting records via the Grid Control when data is grouped is not supported.

Expanded Sorting

The following features are not supported:

Expanded Grouping

The following features are not supported:

Expanded Filtering and Searching

The following features are not supported:

Expanded Selection

Preserving the row selection when data is sorted, grouped or filtered is not supported.

Expanded Summary Calculation

The following features are not supported:

Expanded Data Sources and Presentation

The following features are not supported:

  • Data values rounding.
  • The top/bottom conditional formatting rules (Top10Items, Top10Percent, Bottom10Items, Bottom10Percent, AboveAverage, BelowAverage).

Functional limitations:

Expanded Possible Performance Issues

The GridControl.AutoExpandAllGroups and GridControl.IsRecursiveExpand properties may cause performance issues in GridControl used in Server Mode.

Expanding each group row requires sending a request to an SQL server. When a column participating in grouping has too many unique values, it creates many group rows. Expanding all of them at once may lead to sending a large number of SQL queries, which may take a lot of time to execute.

Is this topic helpful?​​​​​​​