GridView.GetRowCellValue(Int32, GridColumn) Method

Returns the specified cell’s value in the current View.

Namespace: DevExpress.XtraGrid.Views.Grid

Assembly: DevExpress.XtraGrid.v19.1.dll

Declaration

C#

public override object GetRowCellValue(
    int rowHandle,
    GridColumn column
)

VB.NET

Public Overrides Function GetRowCellValue(
    rowHandle As Integer,
    column As GridColumn
) As Object

Parameters

Name	Type	Description
rowHandle	Int32	An integer value representing a handle of the row in which the desired cell resides.
column	GridColumn	A GridColumn object or descendant representing the column that contains the desired cell.

Returns

Type	Description
Object	An object that is the specified cell’s value. null (Nothing in Visual Basic) if the specified cell is not found. In Instant Feedback Mode, an invalid “Non-loaded Value” is immediately returned if the requested cell is not currently loaded.

Remarks

This method overrides the ColumnView.GetRowCellValue method to retrieve requested values for the auto filter row.

For more information, see ColumnView.GetRowCellValue.

Note

In Instant Feedback Mode, this GetRowCellValue method has limitations. It returns a correct value only if the target row has been loaded. Otherwise, it returns a “Non-loaded Value”. You can check to see whether or not the returned value is the “Non-loaded Value” by calling the static BaseEdit.IsNotLoadedValue method.

If you require this value right away (e.g., on a Custom Draw event), skip this value by adding a code, similar to the following:

C#

private void gridView1_CustomDrawGroupRow(object sender, DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventArgs e) {
    GridView view = sender as GridView;
    int index = view.GetDataRowHandleByGroupRowHandle(e.RowHandle);
    var cellValue = view.GetRowCellValue(index, "Mode");
    if (BaseEdit.IsNotLoadedValue(cellValue)) {
        ((GridGroupRowInfo)e.Info).GroupText = "Loading...";
    }
    else {
        int mode = (int)cellValue;
        ((GridGroupRowInfo)e.Info).GroupText += "custom " + mode;
    }
}

VB.NET

Private Sub gridView1_CustomDrawGroupRow(ByVal sender As Object, ByVal e As DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventArgs)
    Dim view As GridView = TryCast(sender, GridView)
    Dim index As Integer = view.GetDataRowHandleByGroupRowHandle(e.RowHandle)
    Dim cellValue = view.GetRowCellValue(index, "Mode")
    If BaseEdit.IsNotLoadedValue(cellValue) Then
        CType(e.Info, GridGroupRowInfo).GroupText = "Loading..."
    Else
        Dim mode As Integer = CInt(Math.Truncate(cellValue))
        CType(e.Info, GridGroupRowInfo).GroupText &= "custom " & mode
    End If
End Sub

Note

Detail pattern Views do not contain data and they are never displayed within XtraGrid. So, the GetRowCellValue member must not be invoked for these Views. The GetRowCellValue 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 GetRowCellValue(Int32, GridColumn) 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#

winforms-preserve-grid-state-on-refresh/CS/RefreshHelperClass.cs#L93

    dataRowHandle = view.GetDataRowHandleByGroupRowHandle(dataRowHandle);
rowInfo.Id = view.GetRowCellValue(dataRowHandle, column);
list.Add(rowInfo);

how-to-compare-two-text-files-line-by-line-using-the-gridcontrol-e1911/CS/WindowsApplication1/Form1.cs#L59

{
     object value1 = gridView1.GetRowCellValue(rowHandle, gridColumnFirstFile);
    object value2 = gridView1.GetRowCellValue(rowHandle, gridColumnSecondFile);

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

{
    object val = (view as GridView).GetRowCellValue(gridHI.RowHandle, gridHI.Column);
    if (val == null || val.ToString() == string.Empty) return;

how-to-immediately-update-gridview-states-after-a-cell-value-is-changed-e4300/CS/WindowsFormsApplication1/Form1.cs#L102

if(e.SummaryProcess == CustomSummaryProcess.Calculate) {
    bool needsToCalulate = (bool)currentView.GetRowCellValue(e.RowHandle, currentView.Columns["Selected"]);
    if(needsToCalulate) {

how-to-merge-grid-cells-e559/CS/WindowsApplication93/Form1.cs#L38

{
    int value1 = Convert.ToInt32(view.GetRowCellValue(e.RowHandle1, e.Column));
    int value2 = Convert.ToInt32(view.GetRowCellValue(e.RowHandle2, e.Column));

VB.NET

winforms-preserve-grid-state-on-refresh/VB/RefreshHelperClass.vb#L100

If dataRowHandle < 0 Then dataRowHandle = view.GetDataRowHandleByGroupRowHandle(dataRowHandle) ' group row
rowInfo.Id = view.GetRowCellValue(dataRowHandle, column)
list.Add(rowInfo)

how-to-compare-two-text-files-line-by-line-using-the-gridcontrol-e1911/VB/WindowsApplication1/Form1.vb#L53

Private Function ValuesAreEqual(ByVal rowHandle As Integer) As Boolean
     Dim value1 As Object = gridView1.GetRowCellValue(rowHandle, gridColumnFirstFile)
    Dim value2 As Object = gridView1.GetRowCellValue(rowHandle, gridColumnSecondFile)

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

If gridHI.HitTest = GridHitTest.RowCell Then
    Dim val As Object = (TryCast(view, GridView)).GetRowCellValue(gridHI.RowHandle, gridHI.Column)
    If val Is Nothing OrElse val.ToString() = String.Empty Then

how-to-immediately-update-gridview-states-after-a-cell-value-is-changed-e4300/VB/WindowsFormsApplication1/Form1.vb#L104

If e.SummaryProcess = CustomSummaryProcess.Calculate Then
    Dim needsToCalulate As Boolean = CBool(currentView.GetRowCellValue(e.RowHandle, currentView.Columns("Selected")))
    If needsToCalulate Then

how-to-merge-grid-cells-e559/VB/WindowsApplication93/Form1.vb#L36

If (e.Column.FieldName = "CategoryID") Then
    Dim value1 As Integer = Convert.ToInt32(view.GetRowCellValue(e.RowHandle1, e.Column))
    Dim value2 As Integer = Convert.ToInt32(view.GetRowCellValue(e.RowHandle2, e.Column))