Hey, that's great! its working now (with no errors), with the
selectcommand that you suggested. but somehow only the first row of
data from my database binds to the datagrid, no matter what i enter in
my search box (which comes out as search_part_no.Text). Im wondering
if my 2nd line below really makes the variable, input_part_no take on
the value of search_part_no.Text. I will might try stored procedures
if this doesnt work.
Using myDA As New MySqlDataAdapter("SELECT part_no, cust_part_no,
customer FROM table1 WHERE part_no LIKE '%...@input_part_no%'",
myConnection)
myDA.SelectCommand.Parameters.AddWithValue("@input_part_no",
search_part_no.Text)
Using myDataSet As New Dataset()
myDA.Fill(myDataset, "table1")
MySQLDataGrid.DataSource = myDataSet
MySQLDataGrid.DataBind()
End Using
End Using
