Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Binding to Data > Data Source Configuration Wizard > SQL Data
All docs
V24.1
WinForms Controls
.NET/.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
Data Source Configuration Wizard
ADO.NET Data
SQL Data
Excel Data Source
Unbound Data Source
Entity Framework Data
Entity Framework (EF) Core
LINQ to SQL
WCF Data Services
OData V4
XPO Data Source
IList and IEnumerable Data Sources
XML Data
OLAP Cube
BindingSource Component Specifics
In-Memory Mode
OLAP Mode
Server Mode
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
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
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Common Features
Security Considerations
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

SQL Data

The Data Source Configuration Wizard allows you to bind the PivotGridControl to an SQL database using the SqlDataSource component. To learn how to do this, see the following topic: Binding to SQL Data.

WinPivot_BoundToSqlDataSource

After you have connected to the SQL data source, you can use the Retrieve Fiels command to retrieve the available data source fields. As an alternative, you can add specific fields manually using the PivotGrid Designer. To do this, use the Run Designer… command.