[essawq]

وهذا اخواني الكود المستخدم للبحث

Sub essaSearch()
Butserch.Enabled = False
Btnserchnew.Enabled = True
If Texserch.Text.Trim = "" Then
MsgBox("ادخل قيمة البحث المطلوبة", MsgBoxStyle.Information)
Exit Sub
End If

If Class1.sqlconn.State = ConnectionState.Open Then
Class1.sqlconn.Close()

End If
sqlstatament = ""
sql1 = ""
Dim firstcont As Boolean = True
If Texserch.Text <> "" Then
If firstcont = False Then
sqlstatament = sqlstatament & "id"
Else
firstcont = False
sqlstatament = sqlstatament & " id= '" & Texserch.Text & "'"
End If
End If
Class1.sqlconn.Open()
sql1 = " select * from cardelivery where" & sqlstatament
Dim cmd As New SqlCommand(sql1)
cmd.Connection = Class1.sqlconn
Dim dr As SqlDataReader = cmd.ExecuteReader
If dr.HasRows Then
dr.Read()
Textrecid.Text = dr.Item("id")
Texname.Text = dr.Item("name")
ComboBox1.SelectedItem = dr.Item("day")
textewm.MyText = dr.Item("medata")
Texmytime1.Text = dr.Item("hour")
Texnumper.Text = dr.Item("numper")
Comboctiy.SelectedValue = dr.Item("nname")
Texrent.Text = dr.Item("rent")
Texnotes.Text = dr.Item("notes")
Combodaybac.Text = dr("daybac").ToString
textbacdate1.MyText = dr("datwbac").ToString
DateTimePicker1.Text = dr("hour1").ToString
Textnumperbac.Text = dr("adadnum").ToString
Textdaymatsh.Text = dr("idcar1").ToString
Textpris.Text = dr("prise").ToString
Textnote1.Text = dr("note1").ToString
Class1.sqlconn.Close()
Else
MsgBox("السجل المطلوب غير موجود", MsgBoxStyle.Information)
End If
End Sub

تحياتي لكم