Hello all.

I have a problem with filtering a DataGridView.

I have a database in MySQL.
Also i have a form that has a DataGridView1 that is showing all the columns from one table from database. That table have the first column with ID Primary Key.
In that form I have 6 text boxes that I use to filter the DataGridView1.
When I enter a word in one of the text boxes and the I press the Search button, everything works great, the DataGridView1 was filtered ok less then the first column (ID).
Also, when I double-click one cell from DataGridView1 V.S. shows me what data I have entered in the database.
The problem I have is that I don't know how to filter also the first column ID of the DataGridView1.
This is the code I use:

Code:
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click

        Dim DV As New DataView(dt_interv)
        DV.RowFilter = String.Format("line like '%{0}%' AND station like '%{1}%' AND error like '%{2}%' AND by like '%{3}%' AND problem like '%{4}%' AND data like '%{5}%'", Me.txtLine.Text, Me.txtsearchStation.Text, Me.txtError.Text, Me.txtBy.Text, Me.txtProblem.Text, Me.txtData.Text)
        DataGridView1.DataSource = DV

    End Sub