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
    [Expand]Database Server Mode
     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]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]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Binding to Data

The following topics describe how to supply the PivotGridControl with data.

  • Binding to Data Overview
    Describes the basic concepts of creating PivotGridControl data sources.

  • Data Source Configuration Wizard
    Walks you through the Data Source Configuration Wizard - a common way of connecting the PivotGridControl to various types of data sources.

  • OLAP Data Source
    Describes how to connect to a cube in a Microsoft Analysis Services server (OLAP server) and provides information on the PivotGridControl functionality limitations imposed when bound to an OLAP server.

  • Database Server Mode
    Describes how to connect a Pivot Grid to a database with a large number of records without performance loss.

  • Unbound Fields
    Describes the capability to create fields that are not bound to any data source fields, and populate them with data manually.

  • Local Data Stores
    Describes how to save Pivot Grid Control data to a file or stream in order to work with it when the original data source becomes unavailable.

  • Asynchronous Mode
    Describes the capability to perform data-aware operations (retrieving data from the server, sorting, grouping, filtering data and calculating summaries) in a background thread.

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