Advanced Filtering Using Filter By Column

[Pete]

Hi,

We have a database that contains thousands of order records. I want to use the Filter By Column feature of the RadGrids in order to sort these columns, but getting thousands of records from the database will take too long. What I'm hoping I can do is using the RadGrid.FilterCommandName function in the ItemCommand to get both the column name and the filter text from the Filter box so that I can call a stored procedure to access the database and pull back only the data I want.

Is it possible to do that? I've tried looking at the tutorials but I can't find anything that gives me what I need, the only tutorials seem to be filtering on the data that's already in the grid and we only have the top 50 rows.

Any help you could provide would be appreciated.

[Shinu]

Hello Pete,

Check the following help documentation which explains the same.
Operating with the FilterExpression of Telerik RadGrid Manually

-Shinu.

[Pete]

Fantastic!!

Thanks Shinu, I tried looking on the site for something exactly like that yesterday and couldn't find it. Now that you've shown me that it works fantastically!

Thanks so much.