1. 存儲(chǔ)過程

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= alter PROCEDURE GetOrderLine @orderId varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; select * from orderLine where OrderId = @orderId; return 123; END GO

 注意 存儲(chǔ)過程只能返回 int 類型，如果返回一個(gè)字符串 ，將會(huì)報(bào)類型轉(zhuǎn)化錯(cuò)誤

2 后臺(tái)調(diào)用

DataTable dt = new DataTable(); string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["BLL.Properties.Settings.ShoppingDBConnectionString"].ToString(); using(SqlConnection conn= new SqlConnection(connStr)){ string callName = "GetOrderLine"; using (SqlCommand command = new SqlCommand(callName, conn)) { command.CommandType = CommandType.StoredProcedure; SqlParameter[] sps = { new SqlParameter("@orderId",SqlDbType.VarChar,50) , new SqlParameter("@return",SqlDbType.Int) //注冊(cè)返回值類型 }; sps[0].Value = "43c7cf15-6b2f-4d18-92b2-dbe827f30dfc"; sps[1].Direction = ParameterDirection.ReturnValue; //返回參數(shù)類型 command.Parameters.AddRange(sps); using(SqlDataAdapter sda =new SqlDataAdapter()){ sda.SelectCommand = command; sda.Fill(dt); //Console.WriteLine(sda.GetFillParameters()[1].Value); Console.WriteLine(sps[1].Value); //取到返回的值 } } } if(dt.Rows.Count>0){ for (int i = 0; i < dt.Rows.Count;i++ ) { Console.WriteLine(dt.Rows[i]["ProductId"]+":"+dt.Rows[i]["ProductPrice"]+":"+dt.Rows[i]["ProductCount"]); } } Console.ReadLine();

AspNet技術(shù)：.Net 調(diào)用存儲(chǔ)過程取到return的返回值，轉(zhuǎn)載需保留來源！

鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。