Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Binding to Data > Binding to Data Overview
A newer version of this page is available.
All docs
V20.2
WinForms Controls
.NET Core Support
Prerequisites
What's Installed
Build an Application
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Binding to Data Overview
Data Source Configuration Wizard
OLAP Data Source
Database Server Mode
Unbound Fields
Optimized Mode and Data Binding API
Local Data Stores
Asynchronous Mode
Data Shaping
Data Analysis
Layout
Focus and Navigation
Printing and Exporting
Appearance
Design-Time Features
Miscellaneous
UI Elements
End-User Capabilities
Examples
Member Tables
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Common Features
Get More Help
API Reference
Download CHM

Binding to Data Overview

  • 2 minutes to read

The PivotGridControl should be connected to an external data source that provides data you wish to display and process. You can bind a PivotGridControl to various types of data sources (an SQL database, an OLAP cube, an object, etc.).

To display data within the PivotGridControl, you need to create Pivot Grid fields that are used to visualize data from specific data source fields.

Note

The PivotGridControl is not automatically updated when the data source is modified. You need to call the PivotGridControl.RefreshData method that will forcibly reload the records in the data source.

Bind a Pivot Grid to Data at Design Time

To bind the PivotGridControl to data, click its smart tag and select one of the following options.

GettingStarted_L1_InvokeDataSourceWizard

  • The Data Source Wizard command allows you to invoke the Data Source Configuration Wizard, which can be used to create various types of data sources.

  • The Choose Data Source combo box allows you to select the existing project data source.

    If necessary, you can create a new data source using the Add Project Data Source… command.

    ChooseDataSource_AddProjectDataSource

    This invokes the Data Source Configuration Wizard, which allows you to create and edit data sources in your application.

  • Choose OLAP Data Source allows you to connect to a cube in a Microsoft Analysis Services server. To learn more, see OLAP Data Source.

Bind a Pivot Grid to Data in Code

The PivotGridControl exposes the PivotGridControl.DataSource and PivotGridControl.DataMember properties used to specify the data source/data member for the Pivot Grid. Note that the PivotGridControl.DataMember property is in effect when a data source (e.g., a DataSet object) contains several lists/tables. To bind the Pivot Grid to data in this case, set its PivotGridControl.DataSource property to the aggregated data source and set its PivotGridControl.DataMember property to the name that identifies the required table.

Note

The following topic lists typical data sources to which the data-aware DevExpress controls can be bound: Traditional Data Binding Methods.

To learn how to bind PivotGridControl to various types of data sources in code, see examples from the Data Source Configuration Wizard section.