[RESOLVED] Datagrid Search Data

[Tengkorak]

i have code to load data from database to DataGridView.

Imports System.Data
Imports System.Data.OleDb
 
Public Class Form1
 
    Dim dt As New DataTable
 
 
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Me.WindowState = FormWindowState.Maximized
    End Sub
 
    Sub setData()
        Try
            Dim scmd As New OleDbCommand
 
            scmd.CommandText = "select prod_id,prod_name,unit,unitprice,unitinstock from inv_t_products order by prod_id"
            scmd.Connection = dbConn
 
            Dim da As New OleDbDataAdapter
            da.SelectCommand = scmd
            da.Fill(dt)
 
            dg.DataSource = dt
 
        Catch ex As Exception
 
        End Try
 
 
    End Sub
 
    Private Sub cmdRefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRefresh.Click
        setData()
    End Sub
 
    Private Sub tFilter_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tFilter.TextChanged
        ' search data
        ' ???
 
 
    End Sub
End Class

at event

Private Sub tFilter_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tFilter.TextChanged
        ' search data
        ' ???
 
 
    End Sub

I Want to find data by prod_name field, when someone fill data to tFilter (textbox).