how to solve this search problem??using datagrids and vb.net?

Question

If cboSearch.Text = "Books" Then
Dim ProductId As String
txtProductID.Text = ProductId
ProductId = "SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN ='" & ProductId & "'"
Dim dt As New DataTable

OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = dt
End If
There's 1 combobox(with the category choices) and 1 textbox...user have to choose the category from the cbobox and type the productid in the txtbox...when i run this code only the info for B0001 is supposed to show on the datagrid, but when i run it..the whole list comes out...how do i solve this??

data is stored in Ms access

set and let statements are not supported anymore

Answer 1

with this new information try this:
dim cn as new adodb.connection
dim rs as new adodb.recordset

set cn = new adodb.connection
set rs = new adodb.reocrdset

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & _
"Data Source=C:\database.mdb"


If cboSearch.Text = "Books" Then
Dim ProductId As String
txtProductID.Text = ProductId
ProductId = "SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN ='" & ProductId & "'"
'Dim dt As New DataTable

rs.Open ProductId , cn, adOpenDynamic, adLockOptimistic

'OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = rs
End If

rs.close
cn.close
set rs = nothing
set cn = nothing

hope I didn't miss anything