Click here to Skip to main content
14,032,595 members
Click here to Skip to main content
Add your own
alternative version


33 bookmarked
Posted 5 Jun 2009
Licenced CPOL

DataGridView Filter Popup

, 5 Jun 2009
Rate this:
Please Sign up or sign in to vote.
A cool way to filter data in a DataGridView.


This article is about a neat way I found to filter data in a DataGridView. This works with all grid view I've ever made with very little code change.


This stems from a similar solution I found. It was too complicated for a beginner like me, so I developed a solution that I could understand.

Using the Code

Step 1: add the following code to the form containing the DataGridView. In this case, the form is called "DataGridViewForm".

Private Sub PartsDataGridView_ColumnHeaderMouseClick(ByVal sender As Object, _
        ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) _
        Handles PartsDataGridView.ColumnHeaderMouseClick

End Sub

Step 2: Add a form to your project called Search.vb and set the properties the way you would like. For instance, I have set the form properties FormBorderStyle=None, TopMost=True, BackgroundColor, etc.

I added a Label, TextBox, and two Buttons.

This is the code-behind of the form.

Public Class Search
    Dim columnIndex As Integer
    Dim columnName As String

    Private Sub Search_Load(ByVal sender As Object, _
                ByVal e As System.EventArgs) Handles Me.Load
        Dim loc As Point
        loc = Control.MousePosition
        Me.Location = loc

        columnIndex = DataGridViewForm.PartsDataGridView.SortedColumn.Index
        columnName = DataGridViewForm.PartsDataGridView.Columns(_
        Label1.Text = columnName
    End Sub

    Private Sub btnSearch_Click(ByVal sender As System.Object, _
            ByVal e As System.EventArgs) Handles btnSearch.Click
            DataGridViewForm.PartsBindingSource.Filter = _
              String.Format("{0} = '{1}'", _
                columnIndex).ColumnName.ToString, TextBox1.Text)
            MessageBox.Show("Database error")
        End Try
    End Sub

    Private Sub btnExit_Click(ByVal sender As System.Object, _
            ByVal e As System.EventArgs) Handles btnExit.Click
    End Sub
End Class

As you can see in the picture, when you click on the header, a window pops up. You enter some text, a part number in this case, and hit the binoculars. Voila!! Your data is filtered.

It's super easy!! This should work with any existing form you have out there!!

Points of Interest

I'm not an expert. One thing that I wasn't able to figure out was how to get the selected column index. So that's why I don't have the Search Form popup when I right click. I need to left click, let the DataGrid sort, and get the index of the sorted column.

Also, I added a button to my ToolStrip to clear the filter and re-fill the DataGrid.

Obviously, you will want to change the code to apply this to your project.

"DataGridViewForm" = "Yourform".
"PartsBindingSource" = "YourBindingSource"
"ShopPartsDataSet" = "YourDataSet"
"PartsDataGridView" = "YourDataGridView"


No history. Brand new!!


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer Hawk Ridge Systems
United States United States
-SolidWorks CSWP
-SolidWorks API Programmer
-Industrial engineer for 15 years
-Robot programmer for 15 years

You may also be interested in...

Comments and Discussions

QuestionSource Code? Pin
Member 305299018-Dec-14 6:46
memberMember 305299018-Dec-14 6:46 
AnswerRe: Source Code? Pin
jesseseger18-Dec-14 6:49
professionaljesseseger18-Dec-14 6:49 
QuestionNice post Pin
Tridip Bhattacharjee12-Dec-13 21:54
professionalTridip Bhattacharjee12-Dec-13 21:54 
GeneralMy vote of 5 Pin
swdev.bali4-Nov-11 3:22
memberswdev.bali4-Nov-11 3:22 
GeneralUpgrades [modified] Pin
aaroncampf27-Jan-11 13:37
memberaaroncampf27-Jan-11 13:37 
GeneralRe: Upgrades [modified] Pin
machmuel31-May-16 21:37
membermachmuel31-May-16 21:37 
GeneralMy vote of 5 Pin
Global Analyser3-Nov-10 11:26
memberGlobal Analyser3-Nov-10 11:26 
QuestionAny Input?? Pin
jesseseger16-Jun-09 1:15
professionaljesseseger16-Jun-09 1:15 
AnswerRe: Any Input?? Pin
ddewart21-Jun-09 11:07
memberddewart21-Jun-09 11:07 
GeneralRe: Any Input?? Pin
jesseseger21-Jun-09 16:42
professionaljesseseger21-Jun-09 16:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web04 | 2.8.190419.4 | Last Updated 5 Jun 2009
Article Copyright 2009 by jesseseger
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid