Data Binding API

Nov 06, 2023
3 minutes to read

Overview

Pivot Grid uses the Binding API to bind Pivot Grid fields to data. Data binding sources can be columns in a data source, calculated expressions, or window calculations.

The following types of bindings are available:

Column Binding: Allows you to bind a Pivot Grid field to a data column in the data source. The Pivot Grid field obtains its values from a field in the data source.
Expression Binding: Allows you to bind a Pivot Grid field to an expression and display the calculated result. The expression can be a formula or an aggregate function.
Calculation Binding: Allows you to bind a Pivot Grid field to a window calculation and display aggregated values in the window.

Each specified binding object is a DataBindingBase descendant. This object is assigned to the Pivot Grid field’s DataBinding property.

The following table illustrates Pivot Grid data processing modes that support the Binding API:

	Legacy and Legacy Optimized	Optimized	Server mode	OLAP
Column Binding
Expression Binding
Calculation Binding

Refer to the following article for more information about data processing modes: Pivot Grid Data Processing Modes.

Column Binding

The following table illustrates the Binding API that can be used in Optimized, Server, and OLAP modes:

Platform	Class
WinForms	DataSourceColumnBinding
WPF	DataSourceColumnBinding
ASP.NET Web Forms	DataSourceColumnBinding

Expression Binding

The tables below illustrate the Binding API that can be used in different Pivot Grid modes.

Optimized and Server modes:

Platform	Class
WinForms	ExpressionDataBinding
WPF	ExpressionDataBinding
ASP.NET Web Forms	ExpressionDataBinding

OLAP mode:

Platform	Class
WinForms	OLAPExpressionBinding
WPF	OlapExpressionBinding
ASP.NET Web Forms	OLAPExpressionBinding

Calculation Binding

The following table illustrates the Binding API that can be used in Optimized mode:

WinForms	WPF	ASP.NET
RankBinding	RankBinding	RankBinding
MovingCalculationBinding	MovingCalculationBinding	MovingCalculationBinding
DifferenceBinding	DifferenceBinding	DifferenceBinding
PercentOfTotalBinding	PercentOfTotalBinding	PercentOfTotalBinding
RunningTotalBinding	RunningTotalBinding	RunningTotalBinding
WindowExpressionBinding	WindowExpressionBinding	WindowExpressionBinding