I am executing a stored procedure in which the dataset that is returned is only 1 row/column. I want to put that value into a textbox. The textbox does not have data binding. How do I get that value into it?
Private Sub GetCostCenter()
Dim myCommand5 As New SqlCommand("Manager_Select_CostCenter", connection)
myCommand5.CommandType = CommandType.StoredProcedure
Dim myDA5 As New SqlDataAdapter
myDA5.SelectCommand = myCommand5
Dim dsCostCenter As New DataSet
txtCostCenter.Text = dsCostCenter `???