Hey peeps,
We have a RadGrid on a page that shows a list of all records in a specific table. With this, the user has selectable options for filtering the information in a seperate space above the Grid (not using the RadGrid filtering options - we are still using an older version of Telerik and the current set does not provide a checkboxlist which we require. The current filtering options does not provide the functionality we need to enable the filtering and besides this, the current options available will be too difficult for our users to understand.).
The user then makes his/her selection from the available filtering options (on the coding side, I programmatically create the SQL query needed to retrieve records according to the selection). This query is then assigned to the SqlDataSource (SqlDataSource1.SelectCommand = 'query'). When the user clicks the Filter button, the RadGrid populates with the results from the new custom query. HOWEVER, when I click on the next page or click on any other page number, the Grid populates from scratch and does not keep the filtering. I have tried to use the FilterExpression on the SqlDataSource, the same happens. First page shows the filtered results but when moving to the next or previous page, the data is "reset".
How can I have the Grid reflect ONLY the data obtained from the new query?
We have a RadGrid on a page that shows a list of all records in a specific table. With this, the user has selectable options for filtering the information in a seperate space above the Grid (not using the RadGrid filtering options - we are still using an older version of Telerik and the current set does not provide a checkboxlist which we require. The current filtering options does not provide the functionality we need to enable the filtering and besides this, the current options available will be too difficult for our users to understand.).
The user then makes his/her selection from the available filtering options (on the coding side, I programmatically create the SQL query needed to retrieve records according to the selection). This query is then assigned to the SqlDataSource (SqlDataSource1.SelectCommand = 'query'). When the user clicks the Filter button, the RadGrid populates with the results from the new custom query. HOWEVER, when I click on the next page or click on any other page number, the Grid populates from scratch and does not keep the filtering. I have tried to use the FilterExpression on the SqlDataSource, the same happens. First page shows the filtered results but when moving to the next or previous page, the data is "reset".
How can I have the Grid reflect ONLY the data obtained from the new query?
1 Answer, 1 is accepted
0
Hello,
In order to implement the desired functionality, I recommend that you set the filter expression of the grid as it is demonstrated here.
Please examine the Operating with the FilterExpression of Telerik RadGrid Manually help topic for additional information.
I hope this helps.
All the best,
Mira
the Telerik team
In order to implement the desired functionality, I recommend that you set the filter expression of the grid as it is demonstrated here.
Please examine the Operating with the FilterExpression of Telerik RadGrid Manually help topic for additional information.
I hope this helps.
All the best,
Mira
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now