WebGrid now supports column grouping along with WebValueList.

In this topic, you will learn how to enable column grouping with WebValueList.

To enable column grouping with WebValueList

1. Bind WebGrid to hierarchical ISDataSource. (Use Products, Supplies and Categories table).
2. Right click on WebGrid and choose WebGrid Designer.
3. Click See all properties. Set GroupByBoxVisible to True.
4. Switch to Advanced tab. Expand RootTable and select GroupColumns.
5. Add a column. Set ColumnMember to SupplierID, GroupInterval to Text, SortOrder to Ascending.
6. Go to Columns. Select SupplierID and go to Value List section.
7. Set DataMember to Suppliers, Data Text Field to CompanyName and Data Value Field to SupplierID.
8. Click See all properties. Set GroupInterval to Text and GroupRowInfoFormat to Supplier : [value].
9. Run the project.