I have a database table which contains more than 1500000 records.
I'm using RadGrid to bind only the top 1000 record from the table at one time using the advanced binding technique (Need Data Source)
I noticed when i use the built in columns filtering feature that it filters only the displayed 1000 record and doesn't filter the database.
I'm using a custom ORM to which returns IList as a data source for the grid.
The example in the demo which binds 300000 records doesn't meet my project requirements, I need to bind only 1000 record at a time.
In other words how we can enable filtering the database table while using something like SELECT TOP 1000 * ......?