PivotDrillDownDataSource.RowCount Property

Gets the number of records in the data source.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

public override int RowCount { get; }

VB.NET

Public Overrides ReadOnly Property RowCount As Integer

Property Value

Type	Description
Int32	An integer value that specifies the number of records in the data source.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RowCount 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#

web-forms-pivot-grid-custom-summary/CS/ASPxPivotGrid_CustomSummary/EventExample.aspx.cs#L21

// Iterate through the records and count the orders.
for (int i = 0; i < ds.RowCount; i++)
{

winforms-pivot-grid-differentiate-between-null-and-zero-values/CS/WindowsApplication53/Form1.cs#L51

{
    if (ds.RowCount == 0) return false;
    for (int i = 0; i < ds.RowCount ; i++)

web-forms-pivot-grid-implement-editable-aspxpivotgrid/CS/Q240884/Default.aspx.cs#L42

decimal diff = newValue - oldValue;
decimal fact = diff == newValue ? diff / source.RowCount : diff / oldValue;
for (int i = 0; i < source.RowCount; i++) {

winforms-pivotgrid-how-to-display-underlying-data/CS/DrillDownDataSourceExample/Form1.cs#L53

gridView1.Columns["OrderDate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
form.Text = string.Format("Underlying Data - {0} Records", dataSource.RowCount);
return form;

winforms-pivotgrid-how-to-edit-and-save-cell-values/CS/HowToEditAndSavePivotCellValues/Form1.cs#L23

PivotDrillDownDataSource ds = e.CreateDrillDownDataSource();
for (int i = 0; i < ds.RowCount; i++) {
    ds.SetValue(i, e.DataField, newValue);

VB.NET

web-forms-pivot-grid-custom-summary/VB/ASPxPivotGrid_CustomSummary/EventExample.aspx.vb#L21

' Iterate through the records and count the orders.
For i As Integer = 0 To ds.RowCount - 1
    Dim row As PivotDrillDownDataRow = ds(i)

winforms-pivot-grid-differentiate-between-null-and-zero-values/VB/WindowsApplication53/Form1.vb#L43

Private Function IsNullValue(ByVal ds As DevExpress.XtraPivotGrid.PivotDrillDownDataSource, ByVal field As DevExpress.XtraPivotGrid.PivotGridField) As Boolean
    If ds.RowCount = 0 Then Return False
    For i As Integer = 0 To ds.RowCount - 1

web-forms-pivot-grid-implement-editable-aspxpivotgrid/VB/Q240884/Default.aspx.vb#L39

Dim diff As Decimal = newValue - oldValue
Dim fact As Decimal = If(diff = newValue, diff / source.RowCount, diff / oldValue)
For i As Integer = 0 To source.RowCount - 1

winforms-pivotgrid-how-to-display-underlying-data/VB/DrillDownDataSourceExample/Form1.vb#L51

gridView1.Columns("OrderDate").DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime
form.Text = String.Format("Underlying Data - {0} Records", dataSource.RowCount)
Return form

winforms-pivotgrid-how-to-edit-and-save-cell-values/VB/HowToEditAndSavePivotCellValues/Form1.vb#L28

Dim ds As PivotDrillDownDataSource = e.CreateDrillDownDataSource()
For i As Integer = 0 To ds.RowCount - 1
    ds.SetValue(i, e.DataField, newValue)