PivotGridFieldBase.DataBinding Property

Gets or sets an object that specifies the Pivot Grid field’s source data.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.1.Core.dll

Declaration

C#

[DefaultValue(null)]
public DataBindingBase DataBinding { get; set; }

VB.NET

<DefaultValue(Nothing)>
Public Property DataBinding As DataBindingBase

Property Value

Type	Default	Description
DataBindingBase	null	A DataBindingBase descendant that specifies the source data and calculation type.

Remarks

Pivot Grid uses the Binding API to bind Pivot Grid fields to data. A data binding source can be a column in the data source or a calculated expression.

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.

Refer to the following topic for more information about binding concepts and usage examples: Data Binding API.

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.

Example

The following example shows how to use the expression binding to bind the FirstValue([ProductName]) expression to the First Product Sold field. The expression returns the first product sold by Sales Persons in each product category:

View Example

Form1.cs

using DevExpress.XtraPivotGrid;
using System.Windows.Forms;

namespace WinPivot_CustomFunctions {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();     
            //  ...
            PivotGridField pivotGridField1 = new PivotGridField() {
                Area = PivotArea.DataArea,
                AreaIndex = 0,
                Caption = "First Product Sold",
                FieldName = "FirstProductSold"
            };
            pivotGridControl1.Fields.Add(pivotGridField1);
            pivotGridField1.DataBinding = new ExpressionDataBinding() { 
                Expression = "FirstValue([ProductName])" };
                //  ...
        }      
    }
}

Form1.vb

Imports DevExpress.XtraPivotGrid

Namespace WinPivot_CustomFunctions
    Partial Public Class Form1
        Inherits Form
        Public Sub New()
            InitializeComponent()
            ' This line of code is generated by Data Source Configuration Wizard
            '  ...
            Dim pivotGridField1 As New PivotGridField() With {
                .Area = PivotArea.DataArea,
                .AreaIndex = 0,
                .Caption = "First Product Sold",
                .FieldName = "FirstProductSold"
            }
            pivotGridControl1.Fields.Add(pivotGridField1)
            pivotGridField1.DataBinding = New ExpressionDataBinding() With {.Expression = "FirstValue([ProductName])"}
            '  ...
        End Sub
    End Class
End Namespace

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataBinding property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

pivot-grid-aggr-examples/CS/Pivot-Aggr-Examples/CodeFiles/CodeExample.cs#L25

};
salesByYearByCountry.DataBinding = new ExpressionDataBinding("Aggr(Sum([Extended Price]), GetYear([OrderDate]), [Country])");
pivotGrid.Fields.Add(salesByYearByCountry);

aspxpivotgrid-how-to-calculate-running-totals-t590001/CS/RunningTotal/Default.aspx.cs#L15

    RunningTotalBinding runningBinding = new RunningTotalBinding(dsBinding, criteria, PivotSummaryType.Sum);
    fieldProductAmount.DataBinding = runningBinding;
}

winforms-pivot-grid-hide-the-grand-total-column-and-text-labels/CS/RemoveGridLinesExample/Form1.cs#L33

fieldYear.Area = PivotArea.RowArea;
fieldYear.DataBinding = new DataSourceColumnBinding("Date", PivotGroupInterval.DateYear);
fieldYear.Name = "FieldYear";

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/CS/PivotGridCustomSummaryExample/Form1.cs#L86

    ExpressionDataBinding savingsBinding = new ExpressionDataBinding("Sum(Iif([Type]='Income', [Value], -[Value]))");
    fieldValueTotal.DataBinding = savingsBinding;
}

winforms-pivot-grid-display-kpi-graphics/CS/WindowsFormsApp_RegularDataSourceKPI/Form1.cs#L18

// Sets a column's data binding and specifies an expression.
KPIField.DataBinding = new ExpressionDataBinding(
    string.Format("(Iif(Sum([{0}])<100000,-1,Iif(Sum([{0}])<150000,0,1)))",

VB.NET

pivot-grid-aggr-examples/VB/Pivot-Aggr-Examples/CodeFiles/CodeExample.vb#L24

salesByYearByCountry.FieldName = "SalesByYearByCountry"
salesByYearByCountry.DataBinding = New ExpressionDataBinding("Aggr(Sum([Extended Price]), GetYear([OrderDate]), [Country])")
pivotGrid.Fields.Add(salesByYearByCountry)

winforms-pivot-grid-connect-to-an-olap-datasource/VB/WinOlapRetrieveFieldsExample/Form1.vb#L52

Dim fieldCountry As PivotGridField = pivotGridControl1.Fields.Add("Country", PivotArea.RowArea)
fieldCountry.DataBinding = New DataSourceColumnBinding("[Customer].[Country].[Country]")
fieldCountry.Name = "fieldCountry"

aspxpivotgrid-how-to-calculate-running-totals-t590001/VB/RunningTotal/Default.aspx.vb#L16

    Dim runningBinding As RunningTotalBinding = New RunningTotalBinding(dsBinding, criteria, PivotSummaryType.Sum)
    fieldProductAmount.DataBinding = runningBinding
Else

winforms-pivot-grid-hide-the-grand-total-column-and-text-labels/VB/RemoveGridLinesExample/Form1.vb#L39

fieldYear.Area = PivotArea.RowArea
fieldYear.DataBinding = New DataSourceColumnBinding("Date", PivotGroupInterval.DateYear)
fieldYear.Name = "FieldYear"

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/VB/PivotGridCustomSummaryExample/Form1.vb#L71

    Dim savingsBinding As New ExpressionDataBinding("Sum(Iif([Type]='Income', [Value], -[Value]))")
    fieldValueTotal.DataBinding = savingsBinding
End Sub