.net grid to display rows, and also have option to group by

Question

Hi,

Does the gridview have any 'group by' functionality?

I need to display a table in the gridview, then allow for sorting on all the database table columns.

I also need to be able to 'group by' on some columns.

Any examples of this kind of functionality?

Answer 1

Unfortunately the built-in gridview doesn't have grouping. Third party controls like the Telerik Grid have this functionality.

Answer 2

Sorting in gridview will result in, effectively, a grouping. Say you have the data:

ID  Item
110 Pineapple
111 Orange
112 Apple
113 Pineapple

Sorting by the Item column would result in:

112 Apple
111 Orange
110 Pineapple
113 Pineapple

Are you looking for something else?

Answer 3

Take a look at the GridViewHelper code here: http://www.agrinei.com/gridviewhelper/gridviewhelper_en.htm, I've used it and found it works a treat