BaseView.DataRowCount Property

Gets how many data rows are contained within the View.

Namespace: DevExpress.XtraGrid.Views.Base

Assembly: DevExpress.XtraGrid.v19.1.dll

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 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 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#

how-to-implement-crud-operations-using-xtragrid-and-linqinstantfeedbacksource-e4499/CS/LinqInstantFeedback/Form1.cs#L48

gridView1.AsyncCompleted += new EventHandler(gridView1_AsyncCompleted);
oldRowsCount = gridView1.DataRowCount;
gridControl.DataSource = linqInstantFeedbackSource1;

how-to-implement-crud-operations-using-xtragrid-and-plinqinstantfeedbacksource-e4501/CS/PLinqServerModeSource/Form1.cs#L36

gridView1.AsyncCompleted += new EventHandler(gridView1_AsyncCompleted);
oldRowsCount = gridView1.DataRowCount;
gridControl.DataSource = plIFS;

how-to-implement-crud-operations-using-xtragrid-and-xpinstantfeedbacksource-e4505/CS/DXServermode2/Form1.cs#L43

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

how-to-specify-visibility-of-rows-in-gridview-during-printing-export-e3174/CS/ExportToXlsx/ExportHelper.cs#L91

ExpandStates = new Dictionary<int, bool>();
for (int i = view.DataRowCount - 1; i >= 0; i--)
    ExpandStates.Add(i, view.GetMasterRowExpanded(i));

gridlookupedit-multiple-selection-web-style-with-the-ok-cancel-buttons-e4048/CS/GridLookUpEditCBMultipleSelection/GridCheckMarksSelection.cs#L80

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

VB.NET

how-to-implement-crud-operations-using-xtragrid-and-linqinstantfeedbacksource-e4499/VB/LinqInstantFeedback/Form1.vb#L48

AddHandler gridView1.AsyncCompleted, AddressOf gridView1_AsyncCompleted
oldRowsCount = gridView1.DataRowCount
gridControl.DataSource = linqInstantFeedbackSource1

how-to-implement-crud-operations-using-xtragrid-and-plinqinstantfeedbacksource-e4501/VB/PLinqServerModeSource/Form1.vb#L35

AddHandler gridView1.AsyncCompleted, AddressOf gridView1_AsyncCompleted
oldRowsCount = gridView1.DataRowCount
gridControl.DataSource = plIFS

how-to-implement-crud-operations-using-xtragrid-and-xpinstantfeedbacksource-e4505/VB/DXServermode2/Form1.vb#L41

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

how-to-implement-crud-operations-using-xtragrid-and-wcfservermodesource-e4503/VB/Example/MainForm.vb#L48

newCustomer = CreateNewCustomer()
OldRowCount = gridView1.DataRowCount
newCustomerKey = newCustomer.CustomerID

how-to-specify-visibility-of-rows-in-gridview-during-printing-export-e3174/VB/ExportToXlsx/ExportHelper.vb#L89

ExpandStates = New Dictionary(Of Integer, Boolean)()
For i As Integer = view.DataRowCount - 1 To 0 Step -1
    ExpandStates.Add(i, view.GetMasterRowExpanded(i))