No value given for one or more required parameters.

Hi,

If the "ID" column is characted based, then use single quotes (') in search condition

"SELECT id,name,rptdate FROM Report where name like '%" & txtSearch.Text & "%' or id= '" & txtSearch.Text & "'"

This may help you. Try it

Regards,
Suresh

from your code block you are testing the connection state. if its open your closing it!

If con.State = Data.ConnectionState.Open Then con.Close()
      Dim adapter As New OleDbDataAdapter(sql, con)
      adapter.Fill(dt)

I would debug your code put in break points and make sure SQL is as expected, and connection object etc are valid and not closed

dbadapter MSDN further reading if required

The error you are getting often comes when you do not pass your parameters properly while calling a stored procedure.

A better way of doing this is through a parameterized query

SELECT id,name,rptdate FROM Report where name like %@name% OR ID like %@ID%

Then add parameters to your parameter collection of the command object. Set the value of the parameters to the text property of your text box.

Hope this helps