Get two fields from a record in VB.Net

[BukHix]

I have been working with VB demos / tutorials for a while now and am now working on a real project.

I have managed a database connection but am unable to figure out how to get the value of a field from my table based on the employee number.

Here is my code so far:

Dim strFname As String
Dim strLname As String
Dim cnn As SqlConnection = _
New SqlConnection("workstation id=XXXXX;packet" & _
   " size=4096;integrated security=SSPI;data source=XXXXX;" & _
   "persist security info=False;initial catalog=DBName")
Dim cmdSelect As New SqlCommand
cnn.Open()

Try
   cmdSelect = cnn.CreateCommand
   cmdSelect.CommandText = "SELECT Name From PREH where Employee=" & txtEmp.Text

Catch ex As Exception
   MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OKOnly, "Error")
End Try

My form has two text boxes one called txtEmpNum and the other txtEmpName. I am trying to write code that will return the name of the employee to the name text box on the LostFocus event which is where that code above is from. Any help would be appreciated.

[trisuglow]

It doesn't look like you're actually executing the command.

Don't you need to do something like this? (copied from MSDN)

Public Sub ReadMyData(myConnString As String)
    Dim mySelectQuery As String = "SELECT OrderID, Customer FROM Orders"
    Dim myConnection As New SqlConnection(myConnString)
    Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
    myConnection.Open()
    Dim myReader As SqlDataReader = myCommand.ExecuteReader()
    Try
        While myReader.Read()
            Console.WriteLine((myReader.GetInt32(0).ToString & ", " & myReader.GetString(1)))
        End While
    Finally
        ' always call Close when done reading.
        myReader.Close()
        ' always call Close when done reading.
        myConnection.Close()
    End Try
End Sub 'ReadMyData