Combobox list filter

headworth · December 20th, 2009, 03:24 AM

Hi All

I have a datagridview on Form1 to filter my columns I have a combobox with a list of my columns if I select one column header in the combobox I can then enter the name in a textbox and the filter works how can I change my code to be able to filter more columns

Code:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            Me.NHEBindingSource.Filter = String.Format("{0} like '%{1}%'", Me.New_HomeDataSet.NHE.EMPLOYEE_NAMEColumn.ColumnName, Me.TextBox1.Text)

        Catch ex As Exception
            MsgBox("ERROR")
        End Try

End Sub

headworth · December 21st, 2009, 11:16 AM

Please can someone help with this ?

I need to be able to select more than one column

Code:

Me.NHEBindingSource.Filter = String.Format("{0} like '%{1}%'", Me.New_HomeDataSet.NHE.EMPLOYEE_GRADEColumn, Me.TextBox1.Text)

        If Nothing Then

        Else
            Me.NHEBindingSource.Filter = String.Format("{0} like '%{1}%'", Me.New_HomeDataSet.NHE.EMPLOYEE_NAMEColumn, Me.TextBox1.Text)
        End If


        
    End Sub

Why so little help on this site