Populate Textbox From DataSource

Can someone tell me what I am doing wrong... I am trying to populate some textboxes from a table by doing a SELECT statment. 
Any help would be greatly appreciated

T.

 

Code:

Dim myConnection As SqlConnection

Dim myCommand As SqlDataAdapter

myConnection = New SqlConnection("Server=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CustomerInfo.mdf;Integrated Security=True;User Instance=True")

myCommand = New SqlDataAdapter("SELECT * FROM [CustomerSalesNum] WHERE [WorkSheetID]= '" & lblRWorkSheetID.Text & "'", myConnection)

Dim ds As DataSet = New DataSet("CustomerSalesNum")

ds = New DataSet("CustomerSalesNums")

tbUPPRice.Text = ds.Tables["CustomerSalesNums"].Rows[0]["Price"].ToString();