VGridControlBase.GetCellValue(RowProperties, Int32) Method

Returns the value of the specified cell.

Namespace: DevExpress.XtraVerticalGrid

Assembly: DevExpress.XtraVerticalGrid.v19.1.dll

Declaration

C#

public virtual object GetCellValue(
    RowProperties props,
    int recordIndex
)

VB.NET

Public Overridable Function GetCellValue(
    props As RowProperties,
    recordIndex As Integer
) As Object

Parameters

Name	Type	Description
props	RowProperties	A RowProperties object that represents the row item that owns the cell.
recordIndex	Int32	A zero-based integer that specifies the index of the record which contains the cell.

Returns

Type	Description
Object	An object that represents the cell’s value. null (Nothing in Visual Basic) if no cell is found.

Remarks

For more information, see Obtaining and Setting Cell Values.

Example

The following sample code handles the VGridControlBase.CellValueChanged event to display the total budget for the university. The total budget is represented by the TotalBudget field. 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 TotalBudget;
   for (int i = 0; i < vGridControl1.RecordCount; i++){
      TotalBudget = 0;
      foreach (BaseRow row in vGridControl1.Rows["budget"].ChildRows){
         for (int j = 0; j < row.RowPropertiesCount; j++){
            TotalBudget += Convert.ToDouble(row.GetRowProperties(j).Value);
         }
      }
      vGridControl1.SetCellValue(vGridControl1.Rows["Total"], i, TotalBudget);
   }
}

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 TotalBudget As Double
   Dim i, j As Integer
   Dim row As BaseRow

   For i = 0 To VGridControl1.RecordCount - 1
      TotalBudget = 0
      For Each row In VGridControl1.Rows("budget").ChildRows
         For j = 0 To row.RowPropertiesCount - 1
            TotalBudget = TotalBudget + Convert.ToDouble(row.GetRowProperties(j).Value)
         Next j
      Next row
      VGridControl1.SetCellValue(VGridControl1.Rows("Total"), i, TotalBudget)
   Next i
End Sub