General Information
WinForms Controls
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
	Prerequisites
	What's Installed
	Common Concepts
	MVVM Framework
	Controls and Libraries
		Windows and Utility Controls
		Dialogs, Notifications and Panels
		Reporting
		Data Grid
		Ribbon, Bars and Menu
		Charts Suite
		Pivot Grid
			Getting Started
			Fundamentals
			Binding to Data
				Binding to Data Overview
				Items Source Configuration Wizard
				OLAP Data Source
				Database Server Mode
				Unbound Fields
				Local Data Stores
				Asynchronous Mode
			Data Shaping
			Data Analysis
			Layout
			Printing and Exporting
			Appearance
			MVVM Enhancements
			Miscellaneous
			UI Elements
			End-User Capabilities
			Examples
		Scheduler
		Spreadsheet
		Rich Text Editor
		Tree List
		Gauge Controls
		Map Control
		Layout Management
		Windows Modern UI
		Printing-Exporting
		Data Editors
		Navigation Controls
		Spell Checker
		Property Grid
		PDF Viewer
		TreeMap Control
		Diagram Control
		Scheduler (legacy)
	Scaffolding Wizard
	Localization
	Redistribution and Deployment
	Get More Help
	API Reference
Xamarin Controls
Windows 10 App Controls
Office File API
Reporting
Report and Dashboard Server
Dashboard
eXpressApp Framework
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
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.
Items Source Configuration Wizard
Walks you through the Items 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 of creating fields that are not bound to any data source fields, and how to 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.

Is this topic helpful?