Vista - 2 text box for search in connected mode

Dear friends I have this code but not work

What I want

I want to design search form to search by (customerid and customername)

This is the code that I want you repair it for me





My problem is:

I can search using one text box on the form



I need to search using 2 text box



I want you imagine what I want



I have a form with some text box

And 2 text box for search

And one button called search

I want if the user type a value in one of text box the search work if he
type 2 value in 2 text box the search work



Its easy but I don't know the information reach to you or not







Dim cn As New OleDbConnection

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Documents and Settings\az\Desktop\A1.mdb;Persist Security
Info=False"

cn.Open()







Dim cmd As New OleDbCommand

cmd.CommandText = "Select * from t1 where CustomerId=?,
customername=?"

cmd.Connection = cn





Dim pr As New OleDbParameter

pr.Value = txtsearchCustomerId.Text

cmd.Parameters.Add(pr)





Dim pr1 As New OleDbParameter

pr1.Value = txtsearchcustomername.Text

cmd.Parameters.Add(pr1)





Dim dr As OleDbDataReader

dr = cmd.ExecuteReader







dr.Read()

If dr.HasRows Then

txtCustomerId.Text = dr(0)

TxtCustomerName.Text = dr(1)

End If





cn.Close()

cmd.Dispose()

dr.Close()



End Sub