[2005] Stored Procedure Output Parameters
I have two stored procedures one generates an output parameter that I then use in the second stored procedure.
Code:
Try
Dim myCommand As New SqlCommand("JP_GetChildren", myConn)
myCommand.CommandType = Data.CommandType.StoredProcedure
myCommand.CommandType = Data.CommandType.StoredProcedure
myCommand.Parameters.Add(New SqlParameter("@ParentRule", Data.SqlDbType.NVarChar))
myCommand.Parameters.Add(New SqlParameter("@PlantID", Data.SqlDbType.NVarChar))
myCommand.Parameters.Add(New SqlParameter("@New_ReleasingRulePrefix", Data.SqlDbType.NVarChar))
myCommand.Parameters.Add(New SqlParameter("@New_ReleasingRuleSuffix", Data.SqlDbType.NVarChar))
myCommand.Parameters.Add(New SqlParameter("@New_PlantID", Data.SqlDbType.NVarChar))
myCommand.Parameters.Add(New SqlParameter("@New_RuleSetID", Data.SqlDbType.NVarChar))
myCommand.Parameters.Add(New SqlParameter("@Count", Data.SqlDbType.Int))
myCommand.Parameters.Add(New SqlParameter("@IDField", Data.SqlDbType.NVarChar))
Dim OParam As New SqlParameter()
OParam.ParameterName = "@IDFieldOut"
OParam.Direction = ParameterDirection.Output
OParam.SqlDbType = SqlDbType.NVarChar
myCommand.Parameters.Add(OParam)
myCommand.Parameters("@ParentRule").Value = txtParentRule.Text
myCommand.Parameters("@PlantID").Value = txtStartingPlantID.Text
myCommand.Parameters("@New_ReleasingRulePrefix").Value = txtReleaseRuleFromPrefix.Text
myCommand.Parameters("@New_ReleasingRuleSuffix").Value = txtReleaseRuleFromSuffix.Text
myCommand.Parameters("@New_PlantID").Value = txtEndingPlantID.Text
myCommand.Parameters("@New_RuleSetID").Value = txtEndingRuleSetID.Text
myCommand.Parameters("@Count").Value = 1
myCommand.Parameters("@IDField").Value = " "
myCommand.Parameters("@IDFieldOut").Value = 0
myCommand.ExecuteNonQuery()
Dim IDField As String = myCommand.Parameters("@IDFieldOut").Value
If i run this stored procedure in sql it does return my parameter. But when i run this code IDField comes back null. Any ideas