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

Export all data

4 Answers 55 Views
Data Virtualization
This is a migrated thread and some comments may be shown as answers.
_frederik
Top achievements
Rank 2
_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

Sort by
0
Vlad
Telerik team
answered on 09 May 2011, 11:39 AM
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
0
_frederik
Top achievements
Rank 2
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
0
Vlad
Telerik team
answered on 09 May 2011, 12:50 PM
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
0
_frederik
Top achievements
Rank 2
answered on 09 May 2011, 01:09 PM
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
Tags
Data Virtualization
Asked by
_frederik
Top achievements
Rank 2
Answers by
Vlad
Telerik team
_frederik
Top achievements
Rank 2
Share this question
or