WebGrid provides built-in column aggregation feature.

This topic will show you how to use column aggregation.

To use column aggregation

1. Bind WebGrid to Products table.
2. Right-click on WebGrid control and choose WebGrid Designer.
3. Switch to Advanced tab and go to RootTable.
4. Set ColumnFooters to Yes.
5. Expand RootTable and select Columns.
6. In UnitPrice column, set AggregateFunction property to Max and FooterText property to "MaxPrice : ".
7. In UnitInStock column, set AggregateFunction property to Sum and FooterText property to "Sum : ".
8. In UnitOnOrder column, set AggregateFunction property to Avg and FooterText property to "Average : ".
9. Run the project.