Bind to Data

• Jun 13, 2022

Topics contained in this section describe how to supply ASPxPivotGrid with data.

• Binding to Data Overview

  Provides general information on binding to databases, XML files, OLAP cubes, etc.

• 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.

• Bind Pivot Grid Fields to Data Columns

  Describes how to bind a Pivot Grid field to a data source column.

• Bind Pivot Grid Fields to Calculated Expressions

  Describes how to create a calculated field and display the result of the calculated expression in the Pivot Grid.

• Bind Pivot Grid Fields to Window Calculations

  Describes how to bind a Pivot Grid field to the result of the window calculation.