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 filter DataGridView data?

Article Information

Article relates to VIBlend DataGridView for WinForms

How To

Filter DataGrid’s 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. Bind the data grid to the Northwind's Invoices table( NWind.mdb is shipped with the product's installation)

C#

try
{
    NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter adapter = new IntegratedDemo.NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter();
    adapter.Fill(nwindDataSet_Inovices.Invoices);
}
catch (System.Exception ex)
{
     MessageBox.Show(ex.Message);
     return;
}

DataTable tbl = this.nwindDataSet_Inovices.Invoices;

Grid1.BoundFields.Clear();
Grid1.BoundPivotColumns.Clear();
Grid1.BoundPivotRows.Clear();
Grid1.BoundPivotValues.Clear();
Grid1.DataSource = null;

Grid1.PivotValuesOnRows = false;

int iColumns = 0;
foreach (DataColumn col in tbl.Columns)
{
    BoundField boundField = new BoundField(col.Caption, col.ColumnName);
    Grid1.BoundFields.Add(boundField);

    if (++iColumns == 5)
    break;
}

Grid1.DataSource = tbl.DefaultView;
Grid1.DataBind();
Grid1.ColumnsHierarchy.AutoResize();
Grid1.RowsHierarchy.AutoResize();

VB .NET
	
Try
    Dim adapter As NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter = New IntegratedDemo.NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter()
    adapter.Fill(nwindDataSet_Inovices.Invoices)
    Catch ex As System.Exception
        MessageBox.Show(ex.Message)
    Return
End Try

Dim tbl As DataTable = Me.nwindDataSet_Inovices.Invoices

Grid1.PivotValuesOnRows = False

Dim iColumns As Integer = 0
For Each col As DataColumn In tbl.Columns
    Dim boundField As New BoundField(col.Caption, col.ColumnName)
    Grid1.BoundFields.Add(boundField)

    iColumns += 1
    If iColumns = 5 Then
        Exit For
    End If
Next col

Grid1.DataSource = tbl.DefaultView
Grid1.DataBind()
Grid1.ColumnsHierarchy.AutoResize()
Grid1.RowsHierarchy.AutoResize()

3. Create a filter group which contains two string filters.

C#

StringFilter stringFilter1 = new StringFilter();
stringFilter1.ComparisonOperator = StringFilterComparisonOperator.NOT_EMPTY;
stringFilter1.Value = "";

StringFilter stringFilter2 = new StringFilter();
stringFilter1.ComparisonOperator = StringFilterComparisonOperator.CONTAINS;
stringFilter1.Value = "a";

FilterGroup<string> filterGroup = new FilterGroup<string>();
filterGroup.AddFilter(FilterOperator.AND, stringFilter1);
filterGroup.AddFilter(FilterOperator.AND, stringFilter2);

VB .NET

Dim stringFilter1 As New StringFilter()
stringFilter1.ComparisonOperator = StringFilterComparisonOperator.NOT_EMPTY
stringFilter1.Value = ""

Dim stringFilter2 As New StringFilter()
stringFilter1.ComparisonOperator = StringFilterComparisonOperator.CONTAINS
stringFilter1.Value = "a"

Dim filterGroup As New FilterGroup(Of String)()
filterGroup.AddFilter(FilterOperator.AND, stringFilter1)
filterGroup.AddFilter(FilterOperator.AND, stringFilter2)

4. Create a new HierarchyItemFilter and set its Filter property to the filter group.

C#

HierarchyItemFilter filter = new HierarchyItemFilter();
filter.Item = Grid1.ColumnsHierarchy.Items[3];
filter.Filter = filterGroup;

VB .NET

Dim filter As New HierarchyItemFilter()
filter.Item = Grid1.ColumnsHierarchy.Items(3)
filter.Filter = filterGroup

5. Apply the filter to the RowHierarchy’s Filters collection

C#

Grid1.RowsHierarchy.Filters.Add(filter);

VB .NET

Grid1.RowsHierarchy.Filters.Add(filter)

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