DataSourceColumnBinding Class

Defines a data binding to a source data column.

Namespace : DevExpress.XtraPivotGrid

Assembly : DevExpress.XtraPivotGrid.v25.2.dll

NuGet Package : DevExpress.Win.PivotGrid

Declaration

C#
VB.NET

csharp

public class DataSourceColumnBinding :
    DataSourceColumnBindingBase

Public Class DataSourceColumnBinding
    Inherits DataSourceColumnBindingBase

Remarks

Pivot Grid uses the Binding API to bind Pivot Grid’s fields to data. DataSourceColumnBinding allows you to bind a Pivot Grid’s field to a data column in the data source. The Pivot Grid’s field obtains its values from a field in the data source.

You can use DataSourceColumnBinding in Optimized, Server, and OLAP data processing modes.

Examples

Optimized and Server Modes

Follow the steps below to bind a Pivot Grid’s field to the data source field in code:

Create a DataSourceColumnBinding instance.
Set the DataSourceColumnBindingBase.ColumnName property to the name of the source data field.
Assign the DataSourceColumnBinding object to the PivotGridFieldBase.DataBinding property.

The following code snippet illustrates how to create the Pivot Grid’s fieldProductAmount field and bind it to the ProductAmount source field:

C#
VB.NET

csharp

PivotGridField fieldProductAmount = new PivotGridField() {
    Area = PivotArea.DataArea,
    Caption = "Product Sales",
    Name = "fProductAmount"
};

DataSourceColumnBinding productAmountBinding = new DataSourceColumnBinding("ProductAmount");
//Bind a field to a column in the data source.
fieldProductAmount.DataBinding = productAmountBinding;
pivotGridControl.Fields.Add(fieldProductAmount);

Dim fieldProductAmount As New PivotGridField()
fieldProductAmount.Area = PivotArea.DataArea
fieldProductAmount.Caption = "Product Sales"
fieldProductAmount.Name = "fProductAmount"

Dim productAmountBinding As New DataSourceColumnBinding("ProductAmount")
'Bind a field to a column in the data source.
fieldProductAmount.DataBinding = productAmountBinding
pivotGridControl.Fields.Add(fieldProductAmount)

Run Demo: Optimized Mode - Field Calculation Bindings module in the XtraPivotGrid MainDemo

OLAP Mode

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

Create a DataSourceColumnBinding instance.
Specify the DataSourceColumnBindingBase.ColumnName property. ColumnName must specify the full name of the bound measure or dimension.
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:

C#
VB.NET

csharp

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

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

Inheritance

Object DataBindingBase DataSourceColumnBindingBase DataSourceColumnBinding