ColumnView.SetRowCellValue(Int32, GridColumn, Object) Method

Assigns a value to a specific cell.

Namespace: DevExpress.XtraGrid.Views.Base

Assembly: DevExpress.XtraGrid.v19.1.dll

Declaration

C#

public void SetRowCellValue(
    int rowHandle,
    GridColumn column,
    object _value
)

VB.NET

Public Sub SetRowCellValue(
    rowHandle As Integer,
    column As GridColumn,
    _value As Object
)

Parameters

Name	Type	Description
rowHandle	Int32	An integer value representing a row handle containing the desired cell.
column	GridColumn	A GridColumn object or descendant representing a column containing the desired cell.
_value	Object	An object representing the value to be assigned.

Remarks

The method does nothing in the following cases:

• the specified row handle is invalid or points to a group row;
• the specified column object is a null reference or belongs to another View.
• the specified row is a non-initialized New Item Row.

Changing a cell value raises the ColumnView.CellValueChanged event.

Note

Detail pattern Views do not contain data and they are never displayed within XtraGrid. So, the SetRowCellValue member must not be invoked for these Views. The SetRowCellValue member can only be used with real Views that are displayed within the Grid Control. The real Views with which an end-user interacts at runtime can be accessed using the following methods.

• GridControl.MainView - returns the top most View in a grid;
• GridControl.FocusedView - returns the focused View;
• GridControl.DefaultView - returns the currently maximized View;
• the sender parameter of View specific events;
• GridView.GetDetailView - returns a detail clone View for a specific master row.

Example

The code sample below iterates through grid records and reduces the “Price” column values by 10 percent.

C#

private void UpdatePrice(DevExpress.XtraGrid.Views.Base.ColumnView View) {
   // Obtain the Price column. 
   DevExpress.XtraGrid.Columns.GridColumn col = View.Columns.ColumnByFieldName("Price");
   if (col == null) return;
   View.BeginSort();
   try {
      // Obtain the number of data rows. 
      int dataRowCount = View.DataRowCount;
      // Traverse data rows and change the Price field values. 
      for (int i = 0; i < dataRowCount; i++) {
         object cellValue = View.GetRowCellValue(i, col);
         double newValue = Convert.ToDouble(cellValue) * 0.9;
         View.SetRowCellValue(i, col, newValue);
      }
   } finally { View.EndSort(); }
}

VB.NET

Private Sub UpdatePrice(ByVal View As DevExpress.XtraGrid.Views.Base.ColumnView)
   ' Obtain the Price column. 
   Dim Col As DevExpress.XtraGrid.Columns.GridColumn = View.Columns.ColumnByFieldName("Price")
   If Col Is Nothing Then Exit Sub 
   View.BeginSort()
   Try 
      ' Obtain the number of data rows. 
      Dim DataRowCount As Integer = View.DataRowCount
      ' Traverse data rows and change the Price field values. 
      Dim I As Integer 
      For I = 0 To DataRowCount - 1
         Dim CellValue As Object = View.GetRowCellValue(I, Col)
         Dim NewValue As Double = Convert.ToDouble(CellValue) * 0.9
         View.SetRowCellValue(I, Col, NewValue)
      Next 
   Finally 
      View.EndSort()
   End Try 
End Sub 

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetRowCellValue(Int32, GridColumn, 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-implement-simple-copy-paste-operations-in-the-gridview-from-a-toolbar-menu-e4528/CS/DXGridCRUDoperations/Main.cs#L50

{
    view.SetRowCellValue(e.RowHandle, view.Columns["FirstName"],personToEdit.FirstName);
    view.SetRowCellValue(e.RowHandle, view.Columns["SecondName"], personToEdit.SecondName);

how-to-implement-a-flashing-cell-in-gridview-e2987/CS/Form1.cs#L62

{
    gridView1.SetRowCellValue(0, gridView1.Columns[0], 100);
    gridView1.SetRowCellValue(1, gridView1.Columns[0], 1000);

how-to-drag-xtragrid-cell-value-in-the-same-manner-as-the-one-ms-excel-provides-e3533/CS/Classes/GridViewHelper.cs#L111

object val = (view as GridView).GetRowCellValue(sourceGridCell.RowHandle, sourceGridCell.Column);
(view as GridView).SetRowCellValue(sourceGridCell.RowHandle, sourceGridCell.Column, "");
(view as GridView).SetRowCellValue(lastMouseDownMoveCell.RowHandle, lastMouseDownMoveCell.Column, val);

how-to-provide-a-new-row-with-initial-values-immediately-after-the-user-activates-a-grid-cell-e1146/CS/WindowsApplication73/Form1.cs#L23

GridView view = sender as GridView;
view.SetRowCellValue(e.RowHandle, view.Columns["Name"], "Noname");
view.SetRowCellValue(e.RowHandle, view.Columns["Date"], DateTime.Today);

how-to-edit-merged-cells-in-gridview-e4117/CS/MyGridControl/MyGridView.cs#L73

    for (int i = 0; i < fEditingCell.MergedCell.MergedCells.Count; i++)
        this.SetRowCellValue(this.fEditingCell.RowHandle + i, this.fEditingCell.Column, CurValue);
}

VB.NET

how-to-implement-simple-copy-paste-operations-in-the-gridview-from-a-toolbar-menu-e4528/VB/DXGridCRUDoperations/Main.vb#L46

If view IsNot Nothing AndAlso personToEdit IsNot Nothing Then
    view.SetRowCellValue(e.RowHandle, view.Columns("FirstName"),personToEdit.FirstName)
    view.SetRowCellValue(e.RowHandle, view.Columns("SecondName"), personToEdit.SecondName)

how-to-implement-a-flashing-cell-in-gridview-e2987/VB/Form1.vb#L58

Private Sub simpleButton1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles simpleButton1.Click
    gridView1.SetRowCellValue(0, gridView1.Columns(0), 100)
    gridView1.SetRowCellValue(1, gridView1.Columns(0), 1000)

how-to-drag-xtragrid-cell-value-in-the-same-manner-as-the-one-ms-excel-provides-e3533/VB/Classes/GridViewHelper.vb#L107

Dim val As Object = (TryCast(view, GridView)).GetRowCellValue(sourceGridCell.RowHandle, sourceGridCell.Column)
TryCast(view, GridView).SetRowCellValue(sourceGridCell.RowHandle, sourceGridCell.Column, "")
TryCast(view, GridView).SetRowCellValue(lastMouseDownMoveCell.RowHandle, lastMouseDownMoveCell.Column, val)

how-to-provide-a-new-row-with-initial-values-immediately-after-the-user-activates-a-grid-cell-e1146/VB/WindowsApplication73/Form1.vb#L21

Dim view As GridView = TryCast(sender, GridView)
view.SetRowCellValue(e.RowHandle, view.Columns("Name"), "Noname")
view.SetRowCellValue(e.RowHandle, view.Columns("Date"), DateTime.Today)

how-to-edit-merged-cells-in-gridview-e4117/VB/MyGridControl/MyGridView.vb#L80

For i As Integer = 0 To fEditingCell.MergedCell.MergedCells.Count - 1
    Me.SetRowCellValue(Me.fEditingCell.RowHandle + i, Me.fEditingCell.Column, CurValue)
Next i