This question is locked. New answers and comments are not allowed.
robert hutchison
Top achievements
Rank 1
Rank 1
robert hutchison
asked on 19 Feb 2010, 03:51 PM
Hi,
I am using RIA Services and a DomainDataSource to connect a RadGridView (with DataPager) to a MS SQL Server table with about 2 million rows in it. Performance is quite good (even for filtering) but grouping works very strangely. I'll try to reduce the problem as follows for the sake of explanation:
With my sample data my data set fills up 19,000 pages. Let's say the records fall into 19 zones (the zone id is one of my fields) with 1,000 pages worth of records for each zone. After I grouped them by zone (I have it set to automatically collapse groups), I see one row per screen (all that would show up is the header) on 19,000 pages instead of seeing 19 header rows, all on one screen.
I'll still have 19,000 pages instead of one page (which I should have, since all the groups have been collapsed)). I'll need to scroll to the 1,001th page to get to my second zone.
Not very useful. I can't imagine that it was designed to work this way and that perhaps, like filtering, there is some "code behind" that I need to implement. Any pointers?
from a "new to telerik' dev,
rob
2 Answers, 1 is accepted
0
Hello rob,
This is just how RIA service will group and page. The grid does not do anything more than transferring the group information to the DomainDataSource.
You can check this article for more info:
http://msdn.microsoft.com/en-us/library/ee707363%28VS.91%29.aspx
RadGridView behaves exactly in the same way as standard Silverlight DataGrid with grouping and paging.
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.
This is just how RIA service will group and page. The grid does not do anything more than transferring the group information to the DomainDataSource.
You can check this article for more info:
http://msdn.microsoft.com/en-us/library/ee707363%28VS.91%29.aspx
RadGridView behaves exactly in the same way as standard Silverlight DataGrid with grouping and paging.
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
robert hutchison
Top achievements
Rank 1
Rank 1
answered on 19 Feb 2010, 04:17 PM
Hi Vlad,
Well, if that is true, then what RIA provides (out of the box) is pretty useless as far as this interface goes.
What I was hoping is someone to look at the problem I was trying to solve, tell me how she or he solved it, suggest an alternative (like a way to trick the DomainDataSource or RadGridView into presenting something useful), or something else (besides starting over).
Thanks,
Rob
Well, if that is true, then what RIA provides (out of the box) is pretty useless as far as this interface goes.
What I was hoping is someone to look at the problem I was trying to solve, tell me how she or he solved it, suggest an alternative (like a way to trick the DomainDataSource or RadGridView into presenting something useful), or something else (besides starting over).
Thanks,
Rob