I used parametized statements with MySqlCommand fine. But then I want
to bind my data to a dataset instead of using a datareader. (am i
using the right jargon?) however, parameters apparently is not a
member of dataAdapters.(
Compiler Error Message: BC30456: 'Parameter' is not a member of
'MySql.Data.MySqlClient.MySqlDataAdapter'.) What should I do??? I have
commented out my tries with executeReader, but my dataAdapter produces
the error I bracketed above.
'Using sqlComm_search As New MySqlCommand("SELECT part_no,
cust_part_no, customer FROM table1 WHERE part_no LIKE '%...@part_no%'",
myConnection)
'sqlComm_search.Parameters.AddWithValue("@part_no",
search_part_no.Text)
'Using sqlRead As MySqlDataReader = sqlComm_search.ExecuteReader()
Using myDA As New MySqlDataAdapter("SELECT part_no, cust_part_no,
customer FROM table1 WHERE part_no LIKE '%...@part_no%'", myConnection)
myDA.Parameter.AddWithValue("@part_no", search_part_no.Text)
Using myDataSet As New Dataset()
myDA.Fill(myDataset, "part numbers")
MySQLDataGrid.DataSource = myDataSet
MySQLDataGrid.DataBind()
End Using
End Using
