PivotGridField.DataBinding Property

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

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public DataBinding DataBinding { get; set; }

VB.NET

Public Property DataBinding As DataBinding

Property Value

Type	Description
DataBinding	A DataBinding object that specifies the source data for the Pivot Grid fields.

Remarks

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.

Refer to the following topics for information on how to bind Pivot Grid fields to data:

• Bind Pivot Grid Fields to Calculated Expressions
• Bind Pivot Grid Fields to Data Columns
• Bind Pivot Grid Fields to Window Calculations

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

The following code snippet illustrates the Pivot Grid’s Product Sales field bound to the Extended Price source column:

MainWindow.xaml

<dxpg:PivotGridControl>
    <dxpg:PivotGridControl.Fields>
      <dxpg:PivotGridField
          Area="DataArea"
          AreaIndex="5"
          Caption="Product Sales"
          CellFormat="C"
          Name="fieldSales">
          <dxpg:PivotGridField.DataBinding>
              <dxpg:DataSourceColumnBinding ColumnName="Extended Price" />
          </dxpg:PivotGridField.DataBinding>
        </dxpg:PivotGridField>
      </dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>

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.

XAML

wpf-pivotgrid-how-to-display-underlying-data/CS/WpfDrillDownDataSourceExample/MainWindow.xaml#L37

Caption="Product Sales">
<dxpg:PivotGridField.DataBinding>
    <dxpg:DataSourceColumnBinding ColumnName="ExtendedPrice"/>

wpf-pivot-grid-obtain-underlying-data/CS/ObtainUnderlyingData/MainWindow.xaml#L64

Name="fieldCountry" >
<dxpg:PivotGridField.DataBinding>
    <dxpg:DataSourceColumnBinding ColumnName="Country"/>

wpf-pivotgrid-hide-column-totals/CS/HowToBindToMDB/MainWindow.xaml#L13

<dxpg:PivotGridField Name="fieldOrderID"  Area="RowArea">
    <dxpg:PivotGridField.DataBinding>
        <dxpg:DataSourceColumnBinding ColumnName="OrderID"/>

wpf-pivot-grid-apply-format-conditions-to-data-cells/CS/WpfPivotGridConditionalFormatting/MainWindow.xaml#L40

                 Name="fieldCountry" AreaIndex="0">
<dxpg:PivotGridField.DataBinding>
    <dxpg:DataSourceColumnBinding ColumnName="Country"/>

wpf-pivotgrid-how-to-display-underlying-data-asynchronously/CS/WpfDrillDownDataSourceExample/MainWindow.xaml#L38

Caption="Product Sales">
<dxpg:PivotGridField.DataBinding>
    <dxpg:DataSourceColumnBinding ColumnName="ExtendedPrice"/>

VB.NET

wpf-pivot-grid-change-summary-display-type/VB/HeaderMenuCustomizationExample/HeaderMenuHelper.vb#L98

Case FieldSummaryDisplayType.AbsoluteVariation
    field.DataBinding = New DifferenceBinding(sourceBinding, CalculationPartitioningCriteria.RowValue, CalculationDirection.DownThenAcross, DifferenceTarget.Previous, DifferenceType.Absolute)
Case FieldSummaryDisplayType.PercentVariation