We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

How to Sumarize and Grouping with GridDataBoundGrid

Hi Clay, I query data from database in groups How can I show this data in GDG with following format: (See attached bitmap) QueryResult_7523.zip

1 Reply

AD Administrator Syncfusion Team May 5, 2005 04:54 AM

There is no support for grouping in a GridDataBoundGrid. If it really is grouped data as in each group is a node in a tree-like display, and when you open a node, you see all the records that share a common value in one of the fields in the record, then you might consider using consider using a GridGroupingControl that does support grouping. You would assign the datatable holding the records to be the datasource of the groupinggrid, and then tell the grouping what field needs to be grouped. If you actually retrieve the grouped data you show in your picture from your database in some kind of accessible datatable, then another option (and probably the simplest option) would be to use a GridControl in virtual mode to display the retrieved data. If you will explain exactly what kind of ADO.NET objects you are working with, then I may be able to offer some more specific recomendations. IE, Do you have a dataset with 2 datatables and a relation between the tables? Or, do you have a single DataTable? Or, something else?

Loader.
Live Chat Icon For mobile
Up arrow icon