PivotDrillDownDataSource.SetValue(Int32, String, Object) Method

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

Namespace: DevExpress.XtraPivotGrid

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

Declaration

public abstract void SetValue(
    int rowIndex,
    string fieldName,
    object value
)
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.

Examples

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

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);
        }
    }
}
See Also