我的存儲過程標題如下:ALTER?proc?[dbo].[brpbomweight]?@cinvcode?varchar(50),?@dec3?decimal(18,6)?outputas
我用以下語法可以輸出值為 0.005623
declare @dec3 decimal(18,6) exec brpbomweight '1201SPE13601', @dec3 output print @dec3
我用以下C#代碼,輸出@dec3永遠都是 0,不知道是什么原因,高人請指教
?
string strConn = command.Class1.cn;
?
??????????? SqlConnection conn = new SqlConnection(strConn);
?
??????????? conn.Open();
?
??????????? SqlCommand cmd = new SqlCommand("brpbomweight", conn);
?
??????????? cmd.CommandType = CommandType.StoredProcedure;
?
??????????? //輸入?yún)?shù)
?
??????????? SqlParameter param1 = new SqlParameter("@cinvcode", SqlDbType.VarChar, 50);
?
??????????? param1.Value = "1201SPE13601"; ??????????????? ??????????? cmd.Parameters.Add(param1);????????
?
??????????? //輸出參數(shù)
?
??????????? SqlParameter param = new SqlParameter("@dec3", SqlDbType.Decimal);
?
??????????? param.Direction = ParameterDirection.Output;
?
??????????? cmd.Parameters.Add(param); ??????????? //執(zhí)行存儲過程
?
??????????? cmd.ExecuteNonQuery();
?
??????????? conn.Close();
?
??????????? //輸出值 ??????????? MessageBox.Show(param.Value.ToString());
c＃中 調(diào)用帶輸出參數(shù)output的存儲過程，如何獲得該返回值？
料青山看我應如是
2018-12-07 07:19:49
