PivotDrillDownDataSource.SetValue(Int32, Int32, Object) Method
Sets the value of the specified data field in the specified row.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v24.2.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
#Declaration
#Parameters
Name | Type | Description |
---|---|---|
row |
Int32 | A zero-based integer that identifies the data row. |
column |
Int32 | A zero-based integer that identifies the column. |
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 Set
#Example
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);
}
}
}