FilterExpression when Datasource and Excel Spreadsheet

[Paul Clark]

Hello

We have a particular grid in our system where a user can say where the data comes from, they can choose a database or excel spreadsheet.

When the grid is bound they can choose which column they want to filter from a drop down and enter the filter in a textbox.

string filterExpression;

filterExpression = "(" + list.SelectedItem.Value + " Like '%" + txt.Text + "%'" + ")";  Grid.MasterTableView.FilterExpression = filterExpression;

The grid is then rebound as usual.

This all works well when they choose a database as their datasource, but when an excel spread sheet is used it does not work.

Should the filter work on excel datasources? or from my code extract above can you see an obvious reason why it would not work?

Thanks

[Daniel]

Hello Paul,

I created a simplified project that demonstrates how to implement this functionality. Please test it locally and let me know if I can assist you further.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.