ContextQMD
Back to Devexpress

Bind Pivot Grid Fields to Data Columns

windowsforms-404010-controls-and-libraries-pivot-grid-binding-to-data-olap-mode-bind-pivot-grid-fields-to-data-columns.md

latest2.1 KB
Original Source

Bind Pivot Grid Fields to Data Columns

  • Aug 05, 2022
  • 2 minutes to read

This topic describes how to use the Binding API to bind a Pivot Grid field to a measure or dimension in OLAP mode.

Design-Time

Follow the steps below to bind a Pivot Grid field to a measure or dimension:

  1. Add a new data field in any of the following ways:

  2. Set the field’s PivotGridFieldBase.DataBinding property to Data Source Column.

  3. Specify the source column in the DataSourceColumnBindingBase.ColumnName property.

RunTime

Follow the steps below to bind a Pivot Grid’s field to a measure or dimension in code in OLAP mode:

  1. Create a DataSourceColumnBinding instance.

  2. Specify the DataSourceColumnBindingBase.ColumnName property. ColumnName must specify the full name of the bound measure or dimension.

  3. Assign the DataSourceColumnBinding object to the PivotGridFieldBase.DataBinding property.

The following code snippet illustrates how to create the fieldCity field and bind it to the City dimension:

csharp
PivotGridField fieldCity = pivotGridControl1.Fields.Add("City", PivotArea.RowArea);
fieldCity.DataBinding = new DataSourceColumnBinding("[Customer].[City].[City]");
fieldCity.Name = "fieldCity";
vb
Dim fieldCity As PivotGridField = pivotGridControl1.Fields.Add("City", PivotArea.RowArea)
fieldCity.DataBinding = New DataSourceColumnBinding("[Customer].[City].[City]")
fieldCity.Name = "fieldCity"

View Example: How to Connect a Pivot Grid to an OLAP Data Source