What does this error mean and how to correct it?

Question

An unhandled exception of type 'System.IndexOutOfRangeException' occurred in system.data.dll

Additional information: An OleDbParameter with ParameterName 'ISBN' is not contained by this OleDbParameterCollection.

The code:
If cboSearch.Text = "Books" Then
Dim ProductId As String
txtProductID.Text = ProductId
Dim dt As New DataTable
OleDbDataAdapter1.SelectCommand.Parameters("ISBN").Value = txtProductID.Text
OleDbDataAdapter1.Fill(dt)
DataGrid1.DataSource = dt
End If
OleDbDataAdapter1.SelectCommand.Parameters("ISBN").Value = txtProductID.Text is highlighted in green

am using vb.net and access

how do u set the parameters with oledbdataadapter

Answer 1

Index out of range exception comes when your trying to access some null index.

example
-----------

now name is the array variable.

you can able to verify that array using name[1].........................name[10]

the array size is 10 now you can able to access upto 10 index

now you try to access name[11].----------------this statement gives error index out of range exception.

Answer 2

Is ISBN one of the index keys? When it says something is out of range it usually means it's not within your search parameters (in other words, it can't find what you want to search on).

Answer 3

Its time for the geek squad....