I'm trying to set the where clause on a LinqDataSource object bound to a GridView programmatically on a button click, but when the GridView rebinds data (for instance, when the user sorts) the Where clause resets back to the empty string. Is there a way to prevent this, or is there a better way to filter my results?
R – How to prevent the LinqDataSource Where clause from resetting on postback
asp.netlinqdatasourcewhere-clause
Best Answer
Perhaps you just add a ViewState property into your page/user control and then retrieve it on all post back?
If that doesn't work, then perhaps bind on the LinqDataSource.Selecting event the fetch property from the viewstate to your where clause?? It all depends