[Solved] Filtering datagridview with textbox

[1635321]

I am using this code to import an excel sheet into the datagridview

        
        Dim dt As DataTable = New DataTable
        dt.Columns.Add(New DataColumn("PartNumber"))
        bs = New BindingSource
        bs.DataSource = dt
        DataGridView1.DataSource = bs
        Dim DtSet As System.Data.DataSet
        Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
        Con = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\ExcelWork.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES""")
        MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", Con)
        MyCommand.TableMappings.Add("Table", "Net-informations.com")
        DtSet = New System.Data.DataSet
        MyCommand.Fill(DtSet)
        DataGridView1.DataSource = DtSet.Tables(0)
        Con.Close()

Now how do I filter it using a text box????