How to clean Excel like filters

[Mauricio]

Hi,

I have enabled the Excel like filtering, but every time I change the DataSource on the radGridView, the filter for a column is not updated. I have tried to clean the filters using:

MasterTemplate.FilterDescriptors.Clear();

MasterTemplate.FilterExpressions.Clear();

But those collections are empty, since I'm not creating my own filters. Any help will be appreciated.
Thanks

[Mauricio]

I found a solution. To update the value that are shown on the "Excel" filters after changing the value of the DataSource, I have
to add a new row to the radGridView. (and then i remove it since I do not need it). Is this the only way to update the value of this filters? I feel like is not the right way to do it.

[Stefan]

Hello Mauricio,

Thank you for writing.

If you have bound the grid and added some filtering for a column via the Excel-like filtering dialog, this automatically creates a FilterDescriptor according to the filtering conditions and this descriptor is added to the FilterDescriptors collection of the template. So when you change the data source of your grid, this filter is preserved if the columns schema of the new data source is the same as the previous one and the filters are cleared if the columns' schema is different. 

If you want to remove the filters upon changing the data source, call the Clear method of the FilterDescriptors collection of the desired template. Alternatively, if you want to keep them and if your data schema is the same, just change the data source and the filter will be kept. Attached you can find a sample project demonstrating both approaches. 

Let me know if you have any additional questions.
 
Greetings,
Stefan
the Telerik team