Hi, I'm having an issue with the filtering feature of the RadGrid. I'm working on a project that acts as an interface for a legacy system. I'm using the Grid control to display the data retrieved from this system.
I'm also using the filter control, which works great. The problem that I'm having is that users are allowed to type date values as numbers only (e.g., "043009") and the legacy system process it and retrieves data for that date (the results for the date column come back as "4/30/09"). The RadGrid however doesn't display any records and displays "No Records to display" instead even though I can see that records are being bound to it. I'm thinking this is because what was entered in the search field doesn't match what is being displayed on the column. Is there any way I can have the RadGrid display the data even if the filtering column TextBox content doesn't match the content of the grid for that column?
Thank you in advance.
I'm also using the filter control, which works great. The problem that I'm having is that users are allowed to type date values as numbers only (e.g., "043009") and the legacy system process it and retrieves data for that date (the results for the date column come back as "4/30/09"). The RadGrid however doesn't display any records and displays "No Records to display" instead even though I can see that records are being bound to it. I'm thinking this is because what was entered in the search field doesn't match what is being displayed on the column. Is there any way I can have the RadGrid display the data even if the filtering column TextBox content doesn't match the content of the grid for that column?
Thank you in advance.
1 Answer, 1 is accepted
0
Hello Juan,
Although the control cannot automatically cater for this setup, you can attach to the ItemCommand event handler, and intercept the command. When the user is filtering for this particular column, you can cancel out the filtering, and either filter the control by applying a custom filter expression, or rebind the grid to filter it at a database level.
All the best,
Yavor
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Although the control cannot automatically cater for this setup, you can attach to the ItemCommand event handler, and intercept the command. When the user is filtering for this particular column, you can cancel out the filtering, and either filter the control by applying a custom filter expression, or rebind the grid to filter it at a database level.
All the best,
Yavor
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.