BaseView.DataRowCount Property

Gets how many data rows are contained within the View.

Namespace: DevExpress.XtraGrid.Views.Base

Assembly: DevExpress.XtraGrid.v24.1.dll

NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation

Declaration

C#

[Browsable(false)]
public int DataRowCount { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property DataRowCount As Integer

Property Value

Type	Description
Int32	An integer value providing a count of the number of data rows in the View.

Remarks

Note that data rows can be hidden within collapsed groups when data grouping is applied. The DataRowCount property returns the total number of data rows regardless of whether they are within collapsed groups or not. Also, the property’s return value is not always the same as the number of records within the associated data source. When data filtering is applied, the DataRowCount property returns the number of rows that match the filter condition.

Note

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

• 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 DataRowCount property.

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-grid-implement-crud-operations-xpinstantfeedbacksource/CS/DXServermode2/Form1.cs#L43

{
    if (customerToEdit != null && gridView1.DataRowCount > oldRowsCount)
    {

winforms-grid-multiple-row-selection-web-style-checkboxes/CS/E1271/CheckMarkSelection.cs#L63

// slow:
for(int i = 0; i < _view.DataRowCount; i++)
    selection.Add(_view.GetRow(i));

winforms-grid-implement-crud-operations-linqservermodesource/CS/LinqServerModeSource/Form1.cs#L71

}
for (int i = 0; i <gridView1.DataRowCount; i++)
{

winforms-grid-move-focused-row-up-down/CS/Form1.cs#L224

int index = view.FocusedRowHandle;
if(index >= view.DataRowCount - 1) return;

why-data-bound-controls-properties-work-incorrectly-until-a-control-become-visible-e2582/CS/WindowsApplication1/Form1.cs#L57

    label2.Text = String.Format("textBox1.Text = {0}", textBox2.Text);
    label3.Text = String.Format("gridView1.DataRowCount = {0}", (_GridControl.MainView as GridView).DataRowCount);
}

VB.NET

winforms-grid-implement-crud-operations-xpinstantfeedbacksource/VB/DXServermode2/Form1.vb#L39

Private Sub gridView1_AsyncCompleted(ByVal sender As Object, ByVal e As EventArgs)
    If customerToEdit IsNot Nothing AndAlso gridView1.DataRowCount > oldRowsCount Then
        For i As Integer = 0 To gridView1.DataRowCount - 1

winforms-grid-multiple-row-selection-web-style-checkboxes/VB/E1271/CheckMarkSelection.vb#L84

' slow:
For i As Integer = 0 To _view.DataRowCount - 1
    selection.Add(_view.GetRow(i))

winforms-grid-implement-crud-operations-linqservermodesource/VB/LinqServerModeSource/Form1.vb#L64

Next i
For i As Integer = 0 To gridView1.DataRowCount - 1
    If result Is gridView1.GetRowCellValue(i, gridView1.Columns("CustomerID")).ToString() Then

winforms-grid-move-focused-row-up-down/VB/Form1.vb#L220

Dim index As Integer = view.FocusedRowHandle
If index >= view.DataRowCount - 1 Then Return
Dim row1 As DataRow = view.GetDataRow(index)

why-data-bound-controls-properties-work-incorrectly-until-a-control-become-visible-e2582/VB/WindowsApplication1/Form1.vb#L51

    label2.Text = String.Format("textBox1.Text = {0}", textBox2.Text)
    label3.Text = String.Format("gridView1.DataRowCount = {0}", TryCast(_GridControl.MainView, GridView).DataRowCount)
End Sub