PivotDrillDownDataSource.SetValue(Int32, PivotGridField, Object) Method

Sets the value of the specified data field in the specified row.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public void SetValue(
    int rowIndex,
    PivotGridField field,
    object value
)

VB.NET

Public Sub SetValue(
    rowIndex As Integer,
    field As PivotGridField,
    value As Object
)

Parameters

Name	Type	Description
rowIndex	Int32	A zero-based integer that identifies the data row.
field	PivotGridField	A PivotGridField object that represents the pivot grid field. Its PivotGridField.FieldName property identifies the column in the data source.
value	Object	An object that represents the new value.

Remarks

If the PivotGrid control is bound to an OLAP cube, data editing is not allowed. In this instance, the SetValue method throws an exception.

Note

The SetValue method is not in effect for unbound columns.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SetValue(Int32, PivotGridField, Object) 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#

wpf-pivot-grid-define-custom-cell-template-to-performing-data-editing/CS/HowToEditCell/MainWindow.xaml.cs#L34

    decimal newValue = (value == 0m) ? factor : value * (1m + factor);
    ds.SetValue(i, fieldExtendedPrice, newValue);
}

VB.NET

wpf-pivot-grid-define-custom-cell-template-to-performing-data-editing/VB/HowToEditCell/MainWindow.xaml.vb#L35

    Dim newValue As Decimal = If(value = 0D, factor, value * (1D + factor))
    ds.SetValue(i, fieldExtendedPrice, newValue)
Next i