RadGridView - Data Virtualization

6 posts, 0 answers
  1. Godwin
    Godwin avatar
    8 posts
    Member since:
    Aug 2011

    Posted 06 Nov 2011 Link to this post

    Hi,

    I have a requirement to populate high volume of data(>50000 rows) in the gridview. I feel data vitualization/lazy loading is a good way to implement this. If I load 500 records at a time and keep loading while scrolling the content the next set, how can I address the following scenarios :
    • Select All option(for the whole underlying datasource)
    • Sorting, grouping features of the grid(for the whole underlying datasource)
    • Export to excel feature(for the whole underlying datasource)

    Assuming all the records are not loaded for the above mentioned scenarios,

    Regards,
    Anand

  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 07 Nov 2011 Link to this post

    Hi Anand,

     Generally you can sort and/or filter all data even with our virtual collection. Please check our demos and documentation! As for the select all and export all I'm afraid that this will need all the data and will defeat the purpose of virtualization. You can use Telerik Reporting to export all the data independently of the virtual collection. 

    Kind regards,
    Vlad
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. UI for WPF is Visual Studio 2017 Ready
  4. Timothy
    Timothy avatar
    8 posts
    Member since:
    Aug 2011

    Posted 25 Jan 2012 Link to this post



    Can you point me to any examples of filtering and sorting RadGridView with Data Virtualization in place?  Specifically something that shows the event handling in the filtering situation whereby I can go back to the server and get the complete list of distinct values for a column to be shown in the filter dialog and then, of course, the event handling needed to repopulate the ItemSource with the filtered results.
    I'm assuming that Sorting will be similar only without the need to fetch any values (just changing the current sort order on the column).

    Thanks.

    Tim
  5. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 26 Jan 2012 Link to this post

    Hi,

     Have you checked our demos for Data Virtualization? Is there anything you don't understand? You can check also our documentation for more info on how to load distinct values.

    Greetings,
    Vlad
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  6. Rahul
    Rahul avatar
    4 posts
    Member since:
    Feb 2012

    Posted 21 Mar 2014 in reply to Vlad Link to this post

    Hii,

    My requirement is also similar. I want to load the gridView data in small chunks at regular intervals of time (async). But by the time the user clicks on the Filter dialog on a column, since all the data in my grid is not yet loaded, I will now make the service call in DistinctValues Loading event (Async call), and in the call back of that call, I will populate the entire Distinct list of values (which may or may not be there in the grid in that column) into the filter dialog list box.

    But my problem is that, I gone through the entire filtering documentation and did-not see how to populate the values into the Filter Dialog when you are not in the DistinctValuesLoading Event. from my call back method I need to populate the values. Can you please let me know how do I do it.


    I tried to do it with ColumnFilterDescriptor, but later realized that it is to add filter on the column
     
    I am little stuck and more over the above link you specified is not working.... its say "An error occurred while processing your request."


    Can you please provide me with a sample demo how to populate the data into the fitler dialog in my own method and not from the DistinctValuesLoading event.


    Thank you in advance!!

    Its little urgent pls :)
  7. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 25 Mar 2014 Link to this post

    Hi,

    The recommended approach when using Data Virtualization (VirtualQueryableCollectionView) and filtering is to work with the FieldFilters only (and not with DistictFilters). 

    In order to configure the column that way, you need to set ShowDistinctFilters="False" for it.
    For example:
    <telerik:GridViewDataColumn DataMemberBinding="{Binding OrderID}" Header="OrderID" ShowDistinctFilters="False"/>
     
    I hope this helps.

    Regards,
    Didie
    Telerik
     

    Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

     
Back to Top
UI for WPF is Visual Studio 2017 Ready