![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif) Code 1 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString()); 2 conn.Open(); 3 SqlCommand MyCommand = new SqlCommand("MYSQL", conn); 4 MyCommand.CommandType = CommandType.StoredProcedure; 5 MyCommand.Parameters.Add(new SqlParameter("@a", SqlDbType.Int)); 6 MyCommand.Parameters["@a"].Value = 10; 7 MyCommand.Parameters.Add(new SqlParameter("@b", SqlDbType.Int)); 8 MyCommand.Parameters["@b"].Value = 20; 9 MyCommand.Parameters.Add(new SqlParameter("@return", SqlDbType.Int)); 10 MyCommand.Parameters["@return"].Direction = ParameterDirection.ReturnValue; 11 MyCommand.ExecuteNonQuery(); 12 Response.Write(MyCommand.Parameters["@return"].Value.ToString()); 13![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif) 二、获取Output输出参数值
1 //存储过程 2 //Create PROCEDURE MYSQL 3 // @a int, 4 // @b int, 5 // @c int output 6 //AS 7 // Set @c = @a + @b 8 //GO 9![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif) Code 1 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString()); 2 conn.Open(); 3 SqlCommand MyCommand = new SqlCommand("MYSQL", conn); 4 MyCommand.CommandType = CommandType.StoredProcedure; 5 MyCommand.Parameters.Add(new SqlParameter("@a", SqlDbType.Int)); 6 MyCommand.Parameters["@a"].Value = 20; 7 MyCommand.Parameters.Add(new SqlParameter("@b", SqlDbType.Int)); 8 MyCommand.Parameters["@b"].Value = 20; 9 MyCommand.Parameters.Add(new SqlParameter("@c", SqlDbType.Int)); 10 MyCommand.Parameters["@c"].Direction = ParameterDirection.Output; 11 MyCommand.ExecuteNonQuery(); 12 Response.Write(MyCommand.Parameters["@c"].Value.ToString());
|
|
|