2 text box for search in connected mode

[a]

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