Hi,
I need some help.
Is there any demo/sample showing how to change the query in sqldatasource preserving all functionality in the RadGrid?
I mean, I have x tables all with the same fields (product bill of material) and by a dropdown list I need to point the datasource to change the query pointing different tables. Update/Insert/delete shall also work. I have tried the above assigning a different query to the datasource but then I loose functionality in sorting, exporting, and so on.
How can I achieve the above?
I need some help.
Is there any demo/sample showing how to change the query in sqldatasource preserving all functionality in the RadGrid?
I mean, I have x tables all with the same fields (product bill of material) and by a dropdown list I need to point the datasource to change the query pointing different tables. Update/Insert/delete shall also work. I have tried the above assigning a different query to the datasource but then I loose functionality in sorting, exporting, and so on.
How can I achieve the above?