New to Telerik UI for WinForms? Download free 30-day trial

How to get all filtered rows in RadGridView with paging


Product Version Product Author
2019.1.117 RadGridView for WinForms Desislava Yordanova


RadGridView exposes two collections that contain data rows:

  • Rows - contains all data rows that belong to RadGridView. Data operations such as grouping, sorting, filtering, etc. do not change the content of the collection or the order in which the row objects exist in the collection.

  • ChildRows - returns the data rows that are currently represented by RadGridView in the order in which they appear. The collection is modified every time a data operation (grouping, sorting, filtering) occurs.

Similar to filtering, sorting and grouping, the ChildRows collection is affected by the paging as well and it contains only the records on the current page. A common scenario is to access the whole filtered collection when the paging is enabled in the order the items appear in the grid.



The RadGridView.MasterTemplate.DataView.Indexer offers the Items collection which contains all the rows in the order in which they appear in the grid. The collection is affected every time a data operation like grouping, sorting, filtering occurs.

It is necessary to cast the MasterTemplate.DataView to GridDataView in order to access the Items collection.

Get data

            GridDataView dataView = this.radGridView1.MasterTemplate.DataView as GridDataView;
            foreach (GridViewRowInfo row in dataView.Indexer.Items)

            Dim dataView As Telerik.WinControls.UI.GridDataView = TryCast(Me.RadGridView1.MasterTemplate.DataView, GridDataView)
        For Each row As GridViewRowInfo In dataView.Indexer.Items

See Also

In this article