r00tsecurity
Top achievements
Rank 1
Rank 1
r00tsecurity
asked on 11 May 2009, 04:42 PM
Hi,
If I use, grouping on a grid that's bind just paged data ( let's say 20 records)..
grouping is being affected on that 20 records. So is there any implementation that grouping regenerates main sql query so that
user sees grouped that thru all records.
EXAMPLE
radGrid1.datasource = sqlHelper.GetPagedData(between 10-30) //brings 20 records thru 10000 records
and let's say radGrid1 is grouped.
So what we see here is just grouped data in 20 records.
what we wanna see is grouped data in 10000 records.
is it possible? how?
ps: in all examples and demos all the data is binded to grid. In real life it never is like so.
If I use, grouping on a grid that's bind just paged data ( let's say 20 records)..
grouping is being affected on that 20 records. So is there any implementation that grouping regenerates main sql query so that
user sees grouped that thru all records.
EXAMPLE
radGrid1.datasource = sqlHelper.GetPagedData(between 10-30) //brings 20 records thru 10000 records
and let's say radGrid1 is grouped.
So what we see here is just grouped data in 20 records.
what we wanna see is grouped data in 10000 records.
is it possible? how?
ps: in all examples and demos all the data is binded to grid. In real life it never is like so.
1 Answer, 1 is accepted
0
Hello,
In order the grid to be able to group the data correctly you should supply it with the whole data source. I hope you will agree with me that if only 20 rows are provided from 10000, there is no way how the grid can compare those 20 rows with the whole data source and group them correctly.
To avoid these behavior you can always group the data in the SQL server.
All the best,
Georgi Krustev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
In order the grid to be able to group the data correctly you should supply it with the whole data source. I hope you will agree with me that if only 20 rows are provided from 10000, there is no way how the grid can compare those 20 rows with the whole data source and group them correctly.
To avoid these behavior you can always group the data in the SQL server.
All the best,
Georgi Krustev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.