VGridControlBase.SetCellValue(BaseRow, Int32, Object) Method

Sets the value of the specified cell.

Namespace: DevExpress.XtraVerticalGrid

Assembly: DevExpress.XtraVerticalGrid.v18.2.dll

Declaration

C#

public virtual void SetCellValue(
    BaseRow gridRow,
    int recordIndex,
    object value
)

VB.NET

Public Overridable Sub SetCellValue(
    gridRow As BaseRow,
    recordIndex As Integer,
    value As Object
)

Parameters

Name	Type	Description
gridRow	BaseRow	A BaseRow descendant that represents the row which contains the cell.
recordIndex	Int32	An integer value which identifies the record in which the cell resides.
value	Object	An object that represents the cell’s new value.

Remarks

For more information, see Obtaining and Setting Cell Values.

Example

The following sample code handles the VGridControlBase.CellValueChanged event to sum up the prices of the selected games in the purchase order list. The image below shows the result.

C#

using DevExpress.XtraVerticalGrid;
using DevExpress.XtraVerticalGrid.Rows;
using DevExpress.XtraVerticalGrid.Events;

private void vGridControl1_CellValueChanged(object sender, CellValueChangedEventArgs e) {
   double sum = 0;
   BaseRow row = vGridControl1.GetFirst();
   while (vGridControl1.GetNext(row) != null){
      if (row.XtraRowTypeID == 2){
         if (Convert.ToBoolean(vGridControl1.GetCellValue(row as MultiEditorRow, 0, 0)) == true)
            sum += Convert.ToDouble(vGridControl1.GetCellValue(row as MultiEditorRow, 0, 1));
      }
      row = vGridControl1.GetNext(row);
   }
   vGridControl1.SetCellValue(rowPrice, 0, sum);
}

VB.NET

Imports DevExpress.XtraVerticalGrid
Imports DevExpress.XtraVerticalGrid.Rows
Imports DevExpress.XtraVerticalGrid.Events

Private Sub VGridControl1_CellValueChanged(ByVal sender As Object, _
ByVal e As CellValueChangedEventArgs) Handles VGridControl1.CellValueChanged
   Dim sum As Double = 0
   Dim row As BaseRow = VGridControl1.GetFirst()
   While Not VGridControl1.GetNext(row) Is Nothing
      If row.XtraRowTypeID = 2 Then
         If Convert.ToBoolean(VGridControl1.GetCellValue(row, 0, 0)) = True Then
            sum = sum + Convert.ToDouble(VGridControl1.GetCellValue(row, 0, 1))
         End If
      End If
      row = VGridControl1.GetNext(row)
   End While
   VGridControl1.SetCellValue(rowPrice, 0, sum)
End Sub

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetCellValue(BaseRow, Int32, 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-provide-in-place-editors-for-row-headers-in-a-vertical-grid-t244577/CS/S170863/Form1.cs#L39

    for(int i = 0; i < vGridControl1.RecordCount; i++)
        vGridControl1.SetCellValue(vGridControl1.GetRowByFieldName("Check"), i, (sender as CheckEdit).Checked);
}

how-to-provide-in-place-editors-for-row-headers-in-the-vertical-grid-t493645/CS/S170863/Form1.cs#L30

    for(int i = 0; i < vGridControl1.RecordCount; i++)
        vGridControl1.SetCellValue(vGridControl1.GetRowByFieldName("Check"), i, (sender as CheckEdit).Checked);
}

how-to-implement-newitemrow-in-vgridcontrol-e4230/CS/VGridControl/CustomVGridControl/VGridControlDescendant.cs#L69

this.FocusedRecordCellIndex = e.CellIndex;
this.SetCellValue(e.Row, RecordCount - 1, e.Value);
this.ShowEditor();

VB.NET

how-to-provide-in-place-editors-for-row-headers-in-a-vertical-grid-t244577/VB/S170863/Form1.vb#L41

For i As Integer = 0 To vGridControl1.RecordCount - 1
    vGridControl1.SetCellValue(vGridControl1.GetRowByFieldName("Check"), i, (TryCast(sender, CheckEdit)).Checked)
Next i

how-to-provide-in-place-editors-for-row-headers-in-the-vertical-grid-t493645/VB/S170863/Form1.vb#L28

For i As Integer = 0 To vGridControl1.RecordCount - 1
    vGridControl1.SetCellValue(vGridControl1.GetRowByFieldName("Check"), i, (TryCast(sender, CheckEdit)).Checked)
Next i

how-to-implement-newitemrow-in-vgridcontrol-e4230/VB/VGridControl/CustomVGridControl/VGridControlDescendant.vb#L62

Me.FocusedRecordCellIndex = e.CellIndex
Me.SetCellValue(e.Row, RecordCount - 1, e.Value)
Me.ShowEditor()