This is a migrated thread and some comments may be shown as answers.

Binding large table to RadGrid + filtering

1 Answer 36 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Taiseer
Top achievements
Rank 1
Taiseer asked on 25 May 2010, 11:04 AM
Dear All,

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 * ......?

1 Answer, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 28 May 2010, 12:01 PM
Hello Tayseer,

The behavior you are facing is expected for the RadGrid, This is actually how RadGrid is designed to work- it applies all actions for the data that it set in the RadGrid DataSource.
To achieve your goal you should apply custom queries in you DB.


Regards,
Maria Ilieva
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Grid
Asked by
Taiseer
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Share this question
or