este es el codigo que tengo, ya me cargan los datos dentro de mi tabla pero no logro hacer el filtro:
Código HTML:
Public Class Almacen
Public consulta
Private Sub Almacen_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Almacen2TableAdapter.Fill(Me.Database4DataSet.Almacen2)
Dim adap As New Database4DataSetTableAdapters.Almacen2TableAdapter()
Dim tabla As New DataTable
tabla = Me.Database4DataSet.Almacen2
adap.Fill(tabla)
Me.DataGridView1.AutoGenerateColumns = True
Me.DataGridView1.Columns("Id").Visible = False
Me.DataGridView1.DataSource = tabla
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
consulta = ("SELECT * FROM Almacen2 WHERE SKU LIKE '%" & TextBox1.Text & "%'")
End Sub
End Class


