Serverside Grouping

[Darran White]

Hi,
We`re evaluating your GridControl product at the moment.
We would like to do Client side grouping and I`d liek to know how easy this is to do with your GridControl.

If possible we would like to hook into your current grouping but do the actual grouping and aggregating for summaries on the server. So when a user applies grouping the aggregating will occur on the sever for summaries. When they click expand on child rows this will send a message to the server to get the grouped child rows. Is this currently possible with your Grid?
If not could similar functionality be applied using your Master-Child tables?

regards

Darran

[Rajasekar]

Hi Darran,

Thank you for your update.

We have checked with your requirement but you cannot bind the exact grouped collections to the particular GridDataTableModel to the Child Model in the server side. But, you can set the ItemsSource of the child model dynamically using the RecordExpanding event of the GridDataControl.Model.Table like below

Code Snippet[C#]

this.dataGrid.Model.Table.RecordExpanding += new GridDataRecordExpandingEventHandler(Table_RecordExpanding);

void Table_RecordExpanding(object sender, GridDataRecordExpandingEventArgs args)
{
string connectionString = string.Format(@"Data Source = {0}", "Northwind.sdf");
Nwind = new Northwind(connectionString);

//dynamically binding the data to child table
args.ChildItemsSource = Nwind.OrderDetails;

args.Handled = true;
}

We have created a sample based on your requirement, In which we have controlled the number of records to be displayed in the child table.

Sample:< http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=NestedChildDemo-1878810287.zip >

Note: The similar query is posted in the Incident #84651, Please update your queries in that respective incident for better follow up.

Please let us know if you have any queries.

Thanks,
Rajasekar