DataGridViewSummaryRowExtensions

Namespace: Wisej.Web.Ext.DataGridViewSummaryRow

Assembly: Wisej.Web.Ext.DataGridViewSummaryRow

Adds summary methods to the DataGridView control.

C\\#

public class DataGridViewSummaryRowExtensions

VB.NET

Public Class DataGridViewSummaryRowExtensions

info

In Visual Basic and C#, you can call this method as an instance method on any object of type Object. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

Methods

AddSummaryRows(grid, summaryType, groupCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in column groupCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
groupCol	String	Name of the column that determines the group break values.
summaryCol	String	name of the column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, summaryPosition, groupCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in column groupCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
summaryPosition	SummaryRowPosition	Indicates the position of the DataGridViewSummaryRow.
groupCol	String	Name of the column that determines the group break values.
summaryCol	String	Name of the column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, groupFromCol, groupToCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in the columns from groupFromCol to groupToCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
groupFromCol	String	Name of the first column that determines the group break values.
groupToCol	String	Name of the last column that determines the group break values.
summaryCol	String	Name of the column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, summaryPosition, groupFromCol, groupToCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in the columns from groupFromCol to groupToCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
summaryPosition	SummaryRowPosition	Indicates the position of the DataGridViewSummaryRow.
groupFromCol	String	Name of the first column that determines the group break values.
groupToCol	String	Name of the last column that determines the group break values.
summaryCol	String	Name of the column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, groupCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in columns groupCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
groupCol	DataGridViewColumn	Column that determines the group break values.
summaryCol	DataGridViewColumn	Column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, summaryPosition, groupCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in columns groupCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
summaryPosition	SummaryRowPosition	Indicates the position of the DataGridViewSummaryRow.
groupCol	DataGridViewColumn	Column that determines the group break values.
summaryCol	DataGridViewColumn	Column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, groupFromCol, groupToCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in the columns from groupFromCol to groupToCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
groupFromCol	DataGridViewColumn	First column that determines the group break values.
groupToCol	DataGridViewColumn	Last column that determines the group break values.
summaryCol	DataGridViewColumn	Column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

AddSummaryRows(grid, summaryType, summaryPosition, groupFromCol, groupToCol, summaryCol, style)

Creates or updates a DataGridViewSummaryRow for each group limited by the values in the columns from groupFromCol to groupToCol .

Parameter	Type	Description
grid	DataGridView	Extension class.
summaryType	SummaryType	Determines the aggregation type.
summaryPosition	SummaryRowPosition	Indicates the position of the DataGridViewSummaryRow.
groupFromCol	DataGridViewColumn	First column that determines the group break values.
groupToCol	DataGridViewColumn	Last column that determines the group break values.
summaryCol	DataGridViewColumn	Column to aggregate.
style	DataGridViewCellStyle	Optional DataGridViewCellStyle for the summary rows.

Returns: DataGridViewSummaryRow[]. Array of the DataGridViewSummaryRow rows displaying the aggregated values.

RemoveSummaryRows(grid)

Removes the all the summary rows.

Parameter	Type	Description
grid	DataGridView	Target DataGridView.

RemoveSummaryRows(grid, summaryPosition)

Removes the summary rows that match the specified summaryPosition .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
summaryPosition	SummaryRowPosition	Position of the summary rows to remove.

RemoveSummaryRows(grid, groupFromCol)

Removes the summary rows grouped by groupFromCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
groupFromCol	String	Name of the first column that determnines the group break values.

RemoveSummaryRows(grid, groupFromCol, groupToCol)

Removes the summary rows grouped by groupFromCol and groupToCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
groupFromCol	String	Name of the first column that determnines the group break values.
groupToCol	String	Name of the last column that determines the group break values.

RemoveSummaryRows(grid, groupFromCol)

Removes the summary rows grouped by groupFromCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
groupFromCol	DataGridViewColumn	First column that determnines the group break values.

RemoveSummaryRows(grid, groupFromCol, groupToCol)

Removes the summary rows grouped by groupFromCol and groupToCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
groupFromCol	DataGridViewColumn	First column that determnines the group break values.
groupToCol	DataGridViewColumn	Last column that determines the group break values.

RemoveSummaryRows(grid, summaryPosition, groupFromCol)

Removes the summary rows that match the specified summaryPosition and grouped by groupFromCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
summaryPosition	SummaryRowPosition	Position of the summary rows to remove.
groupFromCol	String	Name of the first column that determnines the group break values.

RemoveSummaryRows(grid, summaryPosition, groupFromCol, groupToCol)

Removes the summary rows that match the specified summaryPosition and grouped by groupFromCol and groupToCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
summaryPosition	SummaryRowPosition	Position of the summary rows to remove.
groupFromCol	String	Name of the first column that determnines the group break values.
groupToCol	String	Name of the last column that determines the group break values.

RemoveSummaryRows(grid, summaryPosition, groupFromCol, groupToCol)

Removes the summary rows that match the specified summaryPosition and grouped by groupFromCol and groupToCol .

Parameter	Type	Description
grid	DataGridView	Target DataGridView.
summaryPosition	SummaryRowPosition	Position of the summary rows to remove.
groupFromCol	DataGridViewColumn	First column that determnines the group break values.
groupToCol	DataGridViewColumn	Last column that determines the group break values.