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