VIBlend - .NET Controls and Components for Silverlight, WPF and Windows Forms

Home

Products

Downloads

Support

About

WinForms Controls

WinForms DataGrid

Navigation Bars

Ribbon Interface

Calendar Control

TreeView Control

ComboBox Control

ListBox Control

Common Controls

Tab Control

OLAP Pivot Table

Free Controls

Silverlight Controls

Silverlight DataGrid

Scheduler Control

Ribbon Bar Control

Common Controls

Data Entry Controls

List Controls

ComboBox Control

Menu Control

TreeView Control

Navigation Bars

Tab Control

OLAP Pivot Table

WPF Controls

WPF DataGrid

Data Entry Controls

Navigation Bars

WPF Tab Control

How to group the DataGridView by a column?

Article Information

Article relates to VIBlend DataGridView for WinForms

How To

Bind the data grid and group its data.

Solution

To achieve this, follow these steps:

1. Create a new instance of the vDataGridView via drag and drop from the toolbox or create it programmatically.

2. Drag and drop a new NorthWind data set. You can find the NWind.mdb in the VIBlend Controls for WinForms installation package.

3. Drag and drop Categories and Products table adapters.

4. Fill the Categories and Products tables.

C#
this.categoriesTableAdapter1.Fill(this.nwindDataSet1.Categories);
this.productsTableAdapter1.Fill(this.nwindDataSet1.Products);

VB .NET   

Me.categoriesTableAdapter1.Fill(Me.nwindDataSet1.Categories)
Me.productsTableAdapter1.Fill(Me.nwindDataSet1.Products)

5. Create the DataGrid’s BoundFields

C#

Grid1.BoundFields.Add(new BoundField("Product Name", "ProductName"));
Grid1.BoundFields.Add(new BoundField("Unit Price", "UnitPrice"));
Grid1.BoundFields.Add(new BoundField("Category", "CategoryName"));
Grid1.BoundFields.Add(new BoundField("Description", "Description"));

VB .NET

Grid1.BoundFields.Add(New BoundField("Product Name", "ProductName"))
Grid1.BoundFields.Add(New BoundField("Unit Price", "UnitPrice"))
Grid1.BoundFields.Add(New BoundField("Category", "CategoryName"))
Grid1.BoundFields.Add(New BoundField("Description", "Description"))

6. Add the data grid’s grouping column and set the GroupingEnabled property to true.

C#
Grid1.GroupingColumns.Add(new BoundField("Category", "CategoryName"));
Grid1.GroupingEnabled = true;

VB .NET
Grid1.GroupingColumns.Add(New BoundField("Category", "CategoryName"))
Grid1.GroupingEnabled = True

7. Finally, bind the data grid to the data source.

C#

DataTable table = new DataTable();
string categoryName = "CategoryName";
string description = "Description";
table.Merge(this.nwindDataSet1.Products);
table.Columns.Add(this.nwindDataSet1.Categories.CategoryNameColumn.Caption);
table.Columns.Add(this.nwindDataSet1.Categories.DescriptionColumn.Caption);

for (int i = 0; i < table.Rows.Count; i++)
{
	int id = (int)table.Rows[i]["CategoryID"];
	if (id < this.nwindDataSet1.Categories.Rows.Count)
	{
		table.Rows[i][categoryName] = this.nwindDataSet1.Categories.Rows[id][categoryName];
		table.Rows[i][description] = this.nwindDataSet1.Categories.Rows[id][description];
	}
}
        
Grid1.DataSource = table;
Grid1.DataBind();
Grid1.ColumnsHierarchy.AutoResize(AutoResizeMode.FIT_ALL);

VB .NET

Dim table As DataTable = New DataTable()
Dim categoryName As String = "CategoryName"
Dim description As String = "Description"
table.Merge(Me.nwindDataSet1.Products)
table.Columns.Add(Me.nwindDataSet1.Categories.CategoryNameColumn.Caption)
table.Columns.Add(Me.nwindDataSet1.Categories.DescriptionColumn.Caption)

Dim i As Integer = 0
Do While i < table.Rows.Count
Dim id As Integer = CInt(Fix(table.Rows(i)("CategoryID")))

If id < Me.nwindDataSet1.Categories.Rows.Count Then
	table.Rows(i)(categoryName) = Me.nwindDataSet1.Categories.Rows(id)(categoryName)
	table.Rows(i)(description) = Me.nwindDataSet1.Categories.Rows(id)(description)
End If
i += 1
Loop

Grid1.DataSource = table
Grid1.DataBind()
Grid1.ColumnsHierarchy.AutoResize(AutoResizeMode.FIT_ALL)

VIBlend DataGridView for WinForms Grouped by Column

Silverlight Controls	WinForms Controls	Knowledge Base	About Us

Silvelright DataGrid	Ribbon Interface	Technical Support	Blog
Silverlight Editors	WinForms DataGrid
Silverlight Ribbon Bar	Calendar	Downloads	Forum
Navigation Bars	Navigation Bars
Menu & ContextMenu	TreeView	Report a bug	Client Login
ComboBox & ListBox	Tab Control
Silverlight Pivot Table	WinForms Pivot Grid	Request a feature