I have two stored procedures one generates an output parameter that I then use in the second stored procedure.
If i run this stored procedure in sql it does return my parameter. But when i run this code IDField comes back null. Any ideasCode: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




Reply With Quote