This is a migrated thread and some comments may be shown as answers.

Export all data

4 Answers 108 Views

Data Virtualization

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

_frederik asked on 09 May 2011, 10:57 AM

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

4 Answers, 1 is accepted

answered on 09 May 2011, 12:30 PM

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