I want to use retreive a record by providing a requested number in txtTranNumber.text and then the selected row is to be filled in in txtAddress and txtCityState. How can I accomplish this? This is the code I have come up so far.
Dim Conn As SqlConnection = New SqlConnection("workstation id=""just a test"";packet size=1000;user id=userx;data source=just a test" & _
"ist security info=True;initial catalog=Results;password=just a test")
Dim StrCommand As String = " Select address, citystate from results where transno = " ' " & Me.txtTrannumber.Text & " ' "
Dim MyCommand As New SqlCommand(StrCommand, Conn)
Catch ex As SqlException