Customizing the Filter criterion of RadDataFilter.

4 posts, 0 answers
  1. SivaPrasad Bevara
    SivaPrasad Bevara avatar
    73 posts
    Member since:
    Oct 2012

    Posted 04 Feb 2011 Link to this post

    Hi,

    I have to display huge amount of data (millions of records) in a grid. If I take the whole data and display in the Grid, then it is a big performance issue.

    So I am getting the data based on the Page index and page size from the database.

    I wish to use the RadDataFilter with this Grid.
    The problem is, when we use the RadDataFilter it will filter only the data that is loaded in the Grid. And in this case I am not loading the complete data into the grid.

    So I am planning to collect the filter criterion from the RadDataFilter and send it to the database query.
    Please guide me how (in which event) can I get the filter criterion from the rad filter and in which event of the RadDataFilter I need to send the data to the database.

    Please help.

    Regards,
    SivaPrasad.B
  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 04 Feb 2011 Link to this post

    Hi,

     You can bind the filter to RIA services using DomainDataSource (or RadDomainDataSource) if you want filtering on the server. You can check this demo for more info:
    http://demos.telerik.com/silverlight/#DataFilter/DomainDataSource
    http://demos.telerik.com/silverlight/#DomainDataSource/RadDataFilterIntegration

    Regards,
    Vlad
    the Telerik team
    Let us know about your Windows Phone 7 application built with RadControls and we will help you promote it. Learn more>>
  3. DevCraft banner
  4. SivaPrasad Bevara
    SivaPrasad Bevara avatar
    73 posts
    Member since:
    Oct 2012

    Posted 07 Feb 2011 Link to this post

    Hi Vlad,

    Thank you for your quick response.

    From some articles, I understand that RadDomainDataSource does the filtering at the server, on the complete data which is returned from the query.
    This means that we have to get the complete data to the server first, and there it does the filtering and return the filtered data to the UI.

    But in my case, I want to filter the data at the database itself as I have deal with huge amount of data. Returning the complete data to the server and filtering there will reduce the performance.

    Is there any way, by which we can know the filter criterion at the server. So that I can send the filter criterion to the database query, and get only filtered data from the database.

    Please help.

    Regards,
    SivaPrasad.B
  5. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 07 Feb 2011 Link to this post

    Hello,

     Actually both examples will filter directly on the server. For the regular DomainDataSource however you will need to write code - for RadDomainDataSource it is codeless. 

    Greetings,
    Vlad
    the Telerik team
    Let us know about your Windows Phone 7 application built with RadControls and we will help you promote it. Learn more>>
Back to Top