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

Data virtualization query

1 Answer 25 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Rus
Top achievements
Rank 2
Rus asked on 26 Apr 2010, 05:37 PM
Hi

I'm looking for the best way to take advantage of the data virtualization capabilities in the GridView control.

I've built a simple test for this using the Northwind database querying the Orders table. I have built using WCF RIA a NorthwindDomainService providing me with an IQueryable<Order>.

I'm requesting the orders for the gridview by:

            var data = _northwindContext.GetOrdersQuery();

            LoadOperation<Order> loadOrders = _northwindContext.Load( data );
            loadOrders.Completed += ( s, e ) =>
                {
                    Orders = ( s as LoadOperation<Order> ).Entities.AsEnumerable();
                };

( I have also tried binding the entity set as a List<Order> )

What I am seeing is all 830 records (about 277Kb of data) being served immediately even though only 30 records are on the screen.

Is this correct? Is there a way of streaming the data out so the gridview consumes what it needs?

I know that I could use data paging to solve this issue, but a virtualised display would be a better user experience.

The LOB application I am building will have large datasets and a large number of simultaneous connections.

Thanks
Russell











1 Answer, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 27 Apr 2010, 07:08 AM
Hello Russell,

Other possible solution will be to use the grid vertical scrollbar as pager. Please check my blog post for more info.

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.
Tags
GridView
Asked by
Rus
Top achievements
Rank 2
Answers by
Vlad
Telerik team
Share this question
or