PivotDrillDownDataSource.SetValue(Int32, String, Object) Method

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v18.2.Core.dll

Declaration

C#

public abstract void SetValue(
    int rowIndex,
    string fieldName,
    object value
)

VB.NET

Public MustOverride Sub SetValue(
    rowIndex As Integer,
    fieldName As String,
    value As Object
)

Parameters

Name	Type	Description
rowIndex	Int32	A zero-based integer that identifies the data row.
fieldName	String	A String value that specifies the field name.
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.

Example

To edit strings in PivotGridControl, summaries should be turned off. In this example, the PivotGridField.SummaryTypeproperty is set to Minfor the data field.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-edit-strings-in-pivotgridcontrol-e280

Form1.cs

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

namespace PivotGridEditor {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();

            DataTable data = new DataTable();
            data.Columns.Add("row", typeof(string));
            data.Columns.Add("data", typeof(string));
            data.Rows.Add("1", "aaa");
            data.Rows.Add("2", "bbb");
            data.Rows.Add("3", "ccc");
            data.Rows.Add("4", "ddd");
            pivotGridControl1.DataSource = data.DefaultView;
        }

        private void pivotGridControl1_EditValueChanged(object sender, EditValueChangedEventArgs e) {
            PivotDrillDownDataSource ds = e.CreateDrillDownDataSource();
            ds.SetValue(0, "data", e.Editor.EditValue);
        }
    }
}

Form1.vb

Imports System.Data
Imports System.Windows.Forms
Imports DevExpress.XtraPivotGrid

Namespace PivotGridEditor
    Partial Public Class Form1
        Inherits Form

        Public Sub New()
            InitializeComponent()

            Dim data As New DataTable()
            data.Columns.Add("row", GetType(String))
            data.Columns.Add("data", GetType(String))
            data.Rows.Add("1", "aaa")
            data.Rows.Add("2", "bbb")
            data.Rows.Add("3", "ccc")
            data.Rows.Add("4", "ddd")
            pivotGridControl1.DataSource = data.DefaultView
        End Sub

        Private Sub pivotGridControl1_EditValueChanged(ByVal sender As Object, _
                                                       ByVal e As EditValueChangedEventArgs) _
                                                   Handles pivotGridControl1.EditValueChanged
            Dim ds As PivotDrillDownDataSource = e.CreateDrillDownDataSource()
            ds.SetValue(0, "data", e.Editor.EditValue)
        End Sub
    End Class
End Namespace

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetValue(Int32, String, 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#

how-to-edit-strings-in-pivotgridcontrol-e280/CS/Form1.cs#L22

    PivotDrillDownDataSource ds = e.CreateDrillDownDataSource();
    ds.SetValue(0, "data", e.Editor.EditValue);
}

how-to-implement-an-editable-aspxpivotgrid-e1949/CS/Q240884/Default.aspx.cs#L55

Session["PivotData"] = dt;
source.SetValue(
        i, "UnitPrice",

VB.NET

how-to-edit-strings-in-pivotgridcontrol-e280/VB/Form1.vb#L26

    Dim ds As PivotDrillDownDataSource = e.CreateDrillDownDataSource()
    ds.SetValue(0, "data", e.Editor.EditValue)
End Sub

how-to-implement-an-editable-aspxpivotgrid-e1949/VB/Q240884/Default.aspx.vb#L52

    Session("PivotData") = dt
    source.SetValue(i, "UnitPrice", newValue)
Next i