How to get all filtered rows in RadGridView with paging

Environment

Product Version Product Author
2019.1.117 RadGridView for WinForms Desislava Yordanova

Description

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.

get-all-filtered-rows-in-gridview-with-paging

Solution

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)
            {
                Console.WriteLine(row.Cells[0].Value.ToString());
            }

            Dim dataView As Telerik.WinControls.UI.GridDataView = TryCast(Me.RadGridView1.MasterTemplate.DataView, GridDataView)
        For Each row As GridViewRowInfo In dataView.Indexer.Items
            Console.WriteLine(row.Cells(0).Value.ToString())
        Next


See Also

In this article
Not finding the help you need? Improve this article