We can probably give more help if you can be more specific as to the type of search. Lacking that, it looks as if you are on the right track. SQL uses "%" and "_" for wildcarding. A good explanation with examples can be found here.
iv gt this far with the code
just not sure how it ends
Dim con As New SqlConnection
Dim cmd As New SqlCommand
con.ConnectionString = ("")
cmd.Connection = con
cmd.CommandText = "select * from tblCustomer where customerName like @field1 "
cmd = New System.Data.SqlClient.SqlCommand(cmd.CommandText, con)