Bind Pivot Grid Fields to Data Columns
- 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:
Add a new data field in any of the following ways:
Click ‘Run Designer’ in the PivotGrid’s smart tag menu. In the Pivot Grid Designer window, select the Fields page and click
or 
to add a new field. Use one of the ‘Add Field to…’ options in the PivotGrid’s smart tag menu to add a new field to the required area directly. Then, you can specify its properties in the property grid or in the field’s smart tag menu.
Set the field’s PivotGridFieldBase.DataBinding property to
Data Source Column.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:
Create a
DataSourceColumnBindinginstance.Specify the DataSourceColumnBindingBase.ColumnName property.
ColumnNamemust specify the full name of the bound measure or dimension.For dimensions, the full name is composed of a dimension name, followed by a hierarchy name, followed by the name of a level(s). All names should be wrapped within square brackets and separated from one another with the dot symbol. Example: “[Customer].[Customer Geography].[Country]”.
For measures, the full name is composed of the “[Measures].” string followed by the measure name. Example: “[Measures].[Sales Amount]”.
Assign the
DataSourceColumnBindingobject to the PivotGridFieldBase.DataBinding property.
The following code snippet illustrates how to create the fieldCity field and bind it to the City dimension:
PivotGridField fieldCity = pivotGridControl1.Fields.Add("City", PivotArea.RowArea);
fieldCity.DataBinding = new DataSourceColumnBinding("[Customer].[City].[City]");
fieldCity.Name = "fieldCity";