"OleDbException was unhandled - No value given for one or more required parameters."
This is my code:
Dim search As New OleDb.OleDbCommand("SELECT * FROM FilmTable WHERE cboField.selected = txtsearch.text ", con) myDA = New OleDb.OleDbDataAdapter(search) Dim builder As New OleDb.OleDbCommandBuilder(myDA) mydataset = New DataSet() myDA.Fill(mydataset, "FilmTable")
The error is occuring on this line:
All things which are undeclared in the code have been declared publicly so that isnt the problem.
mydataset is getting a value, and "FilmTable" is a table of the underlying database.