Export all data

[_frederik]

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

[Vlad]

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

[_frederik]

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

[Vlad]

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

[_frederik]

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