Not keeping SQL Filter when paging.

[Keith Stephens]

Hello All,
In my codebehind I set the sqldatasource controls filterExpression based on selecting items.

So when the page load I use the sqldatasource and bring back all records, when the user selects "sold Items" I use the sqldatasources FilterExpression to bring back just the "Sold Items" this works just fine, but when I page to the next page all my record show and not just the "Sold Items".

So each time they select an item, I add a diffent filter to the sqldatasource and then I set teh grids DataSourceID to my sqldatasource control then do a grid DataBind();

Like I said it works fine, except when I page to the next page, it's like the filter is removed and is gets everything as if there was no filter, but it should have not gotten everything in the first place because of the filter on the sqldatasource.

How can I fix this,
Thanks,
KS.

[Pavlina]

Hi Keith,

You can use the GridSettingsPersister class as shown in this online example to persist the grid settings, including the filter expression, filter value and filter function for each column. To persist the filtering item data in RadGrid, you need to save and load each column's CurrentFilterFunction and CurrentFilterValue. The GridSettingsPersister does the job for you.

Best wishes,
Pavlina
the Telerik team