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
myDA5.Fill(dsCostCenter)
txtCostCenter.Text = dsCostCenter `???
End Sub
Private Sub GetCostCenter()
Dim myCommand5 As New SqlCommand("Manager_Select_CostCenter", connection)
myCommand5.CommandType = CommandType.StoredProcedure
myCommand5.Parameters.Add("@costcentre", SqlDbType.VarChar)
myCommand5.Parameters("@costcentre").Direction = ParameterDirection.Output
Dim sqlReader As SqlDataReader = myCommand5..ExecuteReader()
sqlReader.Close()
txtCostCenter.Text = myCommand5.Parameters("@costcentre").Value)
End Sub
Asumption: Stored procedure returns a string parameter called costcentre.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
You do not need a reader either. A single value can be retrieved using ExecuteScalar method
Open in new window