PivotGridFieldCollection.AddDataSourceColumn(String, PivotArea) Method

Adds a field to the PivotGridFieldCollection collection.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v21.2.dll

NuGet Packages: DevExpress.Win.Design, DevExpress.Win.PivotGrid

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 value that specifies a column name.
area	PivotArea	A PivotArea value that identifies the area in which the new PivotGridField object will be positioned.

Returns

Type	Description
PivotGridField	The PivotGridField object that was added to the collection.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references 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#

winforms-pivot-grid-hide-empty-columns-and-rows/CS/Data.cs#L21

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

winforms-pivot-grid-hide-specific-columns-and-rows/CS/Data.cs#L21

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

winforms-pivot-split-field-value-cells/CS/Data.cs#L21

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

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

private void InitializeFields() {
    pivotGridControl1.Fields.AddDataSourceColumn("Type", PivotArea.RowArea);
    pivotGridControl1.Fields.AddDataSourceColumn("Product", PivotArea.RowArea);

VB.NET

winforms-pivot-grid-hide-empty-columns-and-rows/VB/Data.vb#L33

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

winforms-pivot-grid-hide-specific-columns-and-rows/VB/Data.vb#L25

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

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

Private Sub InitializeFields()
    pivotGridControl1.Fields.AddDataSourceColumn("Type", PivotArea.RowArea)
    pivotGridControl1.Fields.AddDataSourceColumn("Product", PivotArea.RowArea)