VB.NET 调用存储过程获得多个output 返回值

dc = New SqlCommand("[dbo].[ERP_半成品上架回传]", sqlc)

With dc
.CommandType = CommandType.StoredProcedure
.Parameters.Add("@i_Organization_id", SqlDbType.Int).Value = Organization_id
.Parameters.Add("@i_Transfer_Type", SqlDbType.VarChar, 1).Value = Transfer_Type
.Parameters.Add("@i_FentryID", SqlDbType.Int).Value = FentryID
.Parameters.Add("@i_Batch_Num", SqlDbType.VarChar, 30).Value = Batch_Num
.Parameters.Add("@i_Receive_Locator", SqlDbType.VarChar, 30).Value = Receive_Locator
.Parameters.Add("@i_Quantity", SqlDbType.Int).Value = Quantity

.Parameters.Add("@O_OUT_MSG", SqlDbType.VarChar, 20).Direction = ParameterDirection.Output

.ExecuteNonQuery()

If .Parameters("@O_OUT_MSG").Value() <> "0" Then
Return (.Parameters("@O_OUT_MSG").Value())
End If

End With转载请注明出处:

转载自http://lxfamn.cn/blog

未经允许不得转载：lxfamn » VB.NET 调用存储过程获得多个output 返回值