Click here to Skip to main content
12,402,666 members (72,431 online)
Click here to Skip to main content
Add your own
alternative version

Stats

30.6K views
31 bookmarked
Posted

DataGridView Filter Popup

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

Introduction

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.

Background

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

  Search.Show()
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
        Me.TextBox1.Focus()

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

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

    Private Sub btnExit_Click(ByVal sender As System.Object, _
            ByVal e As System.EventArgs) Handles btnExit.Click
        Me.Close()
    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"

History

No history. Brand new!!

License

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

Share

About the Author

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

http://jesseseger.com

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
memberTridip 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
Heaven20203-Nov-10 11:26
memberHeaven20203-Nov-10 11:26 
QuestionAny Input?? Pin
jesseseger16-Jun-09 1:15
memberjesseseger16-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
memberjesseseger21-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.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160721.1 | Last Updated 5 Jun 2009
Article Copyright 2009 by jesseseger
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid