1.?帶參數的存儲過程
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [ dbo ] . [ sp_select_gua ] @num int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; select mean from tb_gua where id = @num END
C#中的調用
conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = " sp_select_gua " ; cmd.Connection = conn; cmd.Parameters.Add( new SqlParameter( " @num " , SqlDbType.Int)); cmd.Parameters[ " @num " ].Value = Calculator(); c = ( string )cmd.ExecuteScalar();
2.?帶rerurn的存儲過程
?
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [ dbo ] . [ sp_select_gua2 ] ( @num1 int , @num2 int ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; return @num1 + @num2 ; END
C#中的調用
conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = " sp_select_gua2 " ; cmd.Connection = conn; cmd.Parameters.Add( new SqlParameter( " @num1 " , SqlDbType.Int)); cmd.Parameters[ " @num1 " ].Value = Calculator(); cmd.Parameters.Add( new SqlParameter( " @num2 " , SqlDbType.Int)); cmd.Parameters[ " @num2 " ].Value = Calculator(); cmd.Parameters.Add( new SqlParameter( " @return " , SqlDbType.Int)); cmd.Parameters[ " @return " ].Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); c = cmd.Parameters[ " @return " ].Value.ToString();
3. 帶output參數的調用
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [ dbo ] . [ sp_select_gua1 ] ( @num int , @guamean nvarchar ( 1000 ) = '' output, @guaname nvarchar ( 10 ) = '' output) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; select @guaname = name, @guamean = mean from tb_gua where id = @num END
C#中的調用
conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = " sp_select_gua1 " ; cmd.Connection = conn; cmd.Parameters.Add( new SqlParameter( " @num " , SqlDbType.Int)); cmd.Parameters[ " @num " ].Value = Calculator(); cmd.Parameters.Add( new SqlParameter( " @guamean " , SqlDbType.NVarChar, 1000 )); cmd.Parameters[ " @guamean " ].Direction = ParameterDirection.Output; cmd.Parameters.Add( new SqlParameter( " @guaname " , SqlDbType.NVarChar, 10 )); cmd.Parameters[ " @guaname " ].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); c = cmd.Parameters[ " @guamean " ].Value.ToString(); d = cmd.Parameters[ " @guaname " ].Value.ToString();
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
