Export all data

5 posts, 0 answers
  1. _frederik
    _frederik avatar
    3 posts
    Member since:
    Sep 2012

    Posted 09 May 2011 Link to this post

    Hi,

    I am testing your data virtualization and I am having a few issues. 

    First of all it crashes the browser when you click the columns a couple of times to sort data (Loading aprx. 5000 rows).

    Secondly how do you make the radgridview load all of the data and not just what you have scrolled through? I am missing some sort of progressbar saying 10% loaded.. 100% loaded ready for export.  I would prefer not to invest in Telerik reporting. 

    I have used your code exactly as you specify with RIA:
     view = new VirtualQueryableCollectionView(_context.v_ExportSchemas) { LoadSize = 20, VirtualItemCount = 10000 };
    

     var query = _context.GetExportSchemaForSchemaQuery();
            
                view.ItemsLoading += (s, e) =>
                    {
                        var queryToLoad = query.IncludeTotalCount(true).Sort(view.SortDescriptors).Where(view.FilterDescriptors).Skip(e.StartIndex).Take(e.ItemCount);
     
                        _context.Load(queryToLoad).Completed += (sender, args) =>
                        {
                            var lo = (LoadOperation)sender;
                            if (lo.TotalEntityCount != -1 && lo.TotalEntityCount != view.VirtualItemCount)
                            {
                                view.VirtualItemCount = lo.TotalEntityCount;
                            }
     
                            view.Load(e.StartIndex, lo.Entities);
                        };
                    };

    Thanks!

    //Frederik
  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 09 May 2011 Link to this post

    Hello,

     Can you post more info about the crash? Do you get the same on our demos? As to export I'm not sure why you need the virtualization at all if you want to export all data on the client - you need to download all data if you want to export them.

    Regards,
    Vlad
    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
  3. DevCraft banner
  4. _frederik
    _frederik avatar
    3 posts
    Member since:
    Sep 2012

    Posted 09 May 2011 Link to this post

    Could you link to a demo solution?  I am using WCF RIA 1.0 SP1 by the way.

    The reason why I want to use data virtualization is that the user should be able to do filtering and then export the end result.  Then while doing filtering the data should just load in the background.  When the export button is clicked the rest of the remaining data is loaded and the export is done.  But perhaps the amount of data is just too much?  I am using IE9 and Firefox, both browsers crash, but of course it couild be another problem in my code.  I have just exchanged existing code with your Data Virtualization there might be side effects...

    I get this from the crash: Unhandled exception at 0x786cd12d in iexplore.exe: 0x8013150A: 0x8013150a.

    //Frederik
  5. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 09 May 2011 Link to this post

    Hi,

     Indeed if you want to export all data you need to download the data first. You may get communication exception depending of the amount of the data. Our demos for Data Virtualization can be found here

    Greetings,
    Vlad
    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
  6. _frederik
    _frederik avatar
    3 posts
    Member since:
    Sep 2012

    Posted 09 May 2011 Link to this post

    All your demos are working perfectly...

    My Radgridview has 5000+ rows and 50+ columns... Just be scrolling up and down within the grid stops Silverlight from working.

    Maybe it would work with a datapager.  I only want the grid to show a sample of data, as long as the export has all data with the filtering applied. 

    What do you think?

    Frederik
Back to Top
DevCraft banner