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