Binding large table to RadGrid + filtering

2 posts, 0 answers
  1. Taiseer
    Taiseer avatar
    37 posts
    Member since:
    Oct 2007

    Posted 25 May 2010 Link to this post

    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 * ......?
  2. Maria Ilieva
    Maria Ilieva avatar
    4017 posts

    Posted 28 May 2010 Link to this post

    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.

    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.
Back to Top