Iterating GridView>items when RadPager is used

[Peter]

Hi,

I am using RadGridView to select itemsfrom a database to be archived to an external drive, applying complex filters in code-behind, I then need to iterate RadGridView.Items, however because I am also using a RadPager control, I can only access up to a complete page full (in this case 25). How do I iterate all items that are currently available.

Best regards
Peter

[Vlad]

Hi Peter,

 Why not iterate directly the collection bound to the grid/pager?

Regards,
Vlad
the Telerik team

[Peter]

Hi Vlad,

The bound data table is filtered programatically, it is the filtered results that I want to iterate.

So data tabel contains, say, 2000 records,
Filtering leaves, say, 120 records displayed in RadGridView.
But because of RadDataPager page size (25) can only iterate 25 items in RadGridView.Items

Best regards
Peter

[Vlad]

Hello Peter,

 If you bind the grid to a QueryableCollectionView and this view is filtered from the grid filters you can apply the same filters on the view QueryableSourceCollection property to get the filtered items. For example:

var filteredItems = view.QueryableSourceCollection.Where(view.FilterDescriptors);

Kind regards,
Vlad
the Telerik team

[Peter]

Hi Vlad,

Outstanding solution, works perfectly

Best regards
Peter