Adding data from sql database to textboxes and editing the data

Hi, I wish to pull data from an sql table that matches an ID number entered by the user and then that information to be inserted intp the relevant textboxes. But I'm not sure how to do that. Here's what I have so far...

 Dim Con As New SqlClient.SqlConnection(ConnectionString)
Dim strSQL As String = "SELECT * FROM PeopleTBL where Patient_Number = '" & ss & "' (Name, Age, Address) Values (@Name,@Age,@Address)"
        Dim da As New SqlClient.SqlDataAdapter(strSQL, Con)
        Dim ds As New DataSet
        da.Fill(ds, "People_Table")
Textbox1.Text = "@Name"
Textbox1.Text = "@Age"
Textbox1.Text = "@Address"

I dont think thats correct, could somebody help correct it, so that it works correctly?Start Free Trial