DataGridViewSummaryRow

Adds a new method to the DataGridView to automatically generate subtotal and summary rows using several different aggregation models.

This extension is not needed anymore for Wisej 2.5+ as its functionality has been fully integrated into the core Wisej Framework.

https://github.com/iceteagroup/wisej-extensions/tree/master/Wisej.Web.Ext.DataGridViewSummaryRowgithub.com

DataGridViewSummaryRow Source Code

How to Use

To add the values in colSales, grouped by the columns from colRegion to colCountry.

C#

this.dataGridView1.AddSummaryRows(
    SummaryType.Sum, 
    SummaryRowPosition.Above, 
    this.colRegion, 
    this.colCountry, 
    this.colSales, 
    style);

VB.NET

Me.dataGridView1.AddSummaryRows( _
    SummaryType.Sum, _
    SummaryRowPosition.Above, _
    this.colRegion, _
    this.colCountry, _
    this.colSales, _
    style)

Call multiple times to aggregate different columns. It will add the subtotal to the same summary row that matches the group. You can create multiple parent summaries using SummaryRowPosition.Parent.

The method returns an array of DataGridViewSummaryRow rows that you can post process. You can also either pass a DataGridViewCellStyle to the AddSummaryRows method or assign it directly to the newly added rows.