PivotGridFieldCollection.AddDataSourceColumn(String, PivotArea) Method

Creates a field from the specified data source column and add it to the end of the collection.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v23.2.dll

NuGet Package: DevExpress.Web

Declaration

C#

public PivotGridField AddDataSourceColumn(
    string columnName,
    PivotArea area
)

VB.NET

Public Function AddDataSourceColumn(
    columnName As String,
    area As PivotArea
) As PivotGridField

Parameters

Name	Type	Description
columnName	String	A string that is a name of the data source column.
area	PivotArea	A PivotArea value that specifies the header area.

Returns

Type	Description
PivotGridField	A PivotGridField object that is the created field.

Remarks

For Optimized data engine mode, the method creates the DataSourceColumnBinding data binding for a new field instead of specifying the FieldName property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the AddDataSourceColumn(String, PivotArea) method.

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#

web-forms-pivot-grid-hide-particular-rows-and-columns/CS/ASPxPivotGrid_HidingColumnsAndRows/Data.cs#L22

public static void FillPivot(ASPxPivotGrid pivot) {
    pivot.Fields.AddDataSourceColumn(Employee, PivotArea.RowArea);
    pivot.Fields.AddDataSourceColumn(Widget, PivotArea.RowArea);

VB.NET

web-forms-pivot-grid-hide-particular-rows-and-columns/VB/ASPxPivotGrid_HidingColumnsAndRows/Data.vb#L34

Public Sub FillPivot(ByVal pivot As ASPxPivotGrid)
    pivot.Fields.AddDataSourceColumn(Employee, PivotArea.RowArea)
    pivot.Fields.AddDataSourceColumn(Widget, PivotArea.RowArea)