majik655
Enthusiast
::EDIT::
I have figured out my original question...I have another one if someone can help.
I have a datagridview show my access database ...
I have textbox1.text with the following code to search a specified column and show only those in the datagridview... I would like to add another textbox to search those from textbox1 to refine the search more...this textbox2 would search a different column..
Here is the code I am currently using...
When this search is done... I would like the next textbox to search JobNumber column to refine the search from textbox1
THANK YOU!!!
I have figured out my original question...I have another one if someone can help.
I have a datagridview show my access database ...
I have textbox1.text with the following code to search a specified column and show only those in the datagridview... I would like to add another textbox to search those from textbox1 to refine the search more...this textbox2 would search a different column..
Here is the code I am currently using...
Code:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(dt)
Dim da As New OleDbDataAdapter
da = New OleDbDataAdapter("Select * from QualityIssues where CustomerNames Like '%" & TextBox1.Text & "%'", con)
da.Fill(dt)
DataGridView1.DataSource = dt.DefaultView
DataGridView1.Columns("ID").Visible = False
con.Close()
End Sub
When this search is done... I would like the next textbox to search JobNumber column to refine the search from textbox1
THANK YOU!!!