Apply Filter to underlying datasource

[John]

I'm binding GridView to a datasource referencing a dataset with filtering enabled. I understand the filtered rows are in the ChildRows collection - but how do apply that to the underlying datasource so I can remove the filtered records?

[Stefan]

Hello John,

Thank you for writing.

The filtering functionality of RadGridView does not work with the underlying data source. It filters the available rows in the grid UI and the resulted rows can be found in the ChildRows collection as you mentioned. 

A possible approach might be to iterate the rows in the data set, or in the Rows collection of the grid and delete every row that does not exist in the ChildRows collection.

I hope this helps.
 
Greetings,
Stefan
the Telerik team