Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Collapse]Binding to Data
     Binding to Data Overview
    [Expand]Data Source Configuration Wizard
    [Expand]OLAP Data Source
    [Collapse]Database Server Mode
      Binding to a Data Source Using Entity Framework
      Binding to a Data Source Using 'LINQ to SQL Classes'
     Unbound Fields
     Local Data Stores
     Asynchronous Mode
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Database Server Mode

If you need to connect a pivot grid control to a database with a large number of records, you can use server mode. Server mode has been specifically designed to work with large datasets. In this mode, the pivot grid control performs data-aware operations on the database server side. That ensures quick access to data, even if grouping and filtering are used.

For end-users, the pivot grid control functions identically in regular and server modes. In server mode, they can scroll the pivot grid, sort, group and filter data, and calculate summaries.

The Pivot Grid Control can perform data-aware operations (retrieving data from the server, grouping, filtering data and calculating summaries) in a background thread, allowing the entire application to stay responsive while these operations are in progress. To enable asynchronous mode, set the PivotGridOptionsBehaviorBase.UseAsyncMode property to true.

Expanded Server Mode Data Sources

The PivotGridControl automatically operates in server mode if it is bound to an appropriate data source. Use one of the following data sources to enable this mode.

Data Access Technology Server Mode Data Source
Entity Framework 4+ EntityServerModeSource
LINQ to SQL LinqServerModeSource
Note

The LinqServerModeSource and EntityServerModeSource are read-only data sources.

Expanded Server Mode Limitations

In server mode, the pivot grid control doesn't have simultaneous access to bound data in its entirety and this imposes certain limitations on the pivot grid's features. See the list below for information on features that are not supported in server mode.

Expanded Examples

The following step-by-step tutorials demonstrate how to bind a Pivot Grid control to different data sources.

How would you rate this topic?​​​​​​​