1.获取Return返回值//存储过程//Create PROCEDURE MYSQL//@a int,//@b int//AS//return @a + @b//GOSqlConnection conn=newSqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());
conn.Open();
SqlCommand MyCommand=newSqlCommand("MYSQL", conn);
MyCommand.CommandType=CommandType.StoredProcedure;
MyCommand.Parameters.Add(newSqlParameter("@a", SqlDbType.Int));
MyCommand.Parameters["@a"].Value=10;
MyCommand.Parameters.Add(newSqlParameter("@b", SqlDbType.Int));
MyCommand.Parameters["@b"].Value=20;
MyCommand.Parameters.Add(newSqlParameter("@return", SqlDbType.Int));
MyCommand.Parameters["@return"].Direction=ParameterDirection.ReturnValue;
MyCommand.ExecuteNonQuery();
Response.Write(MyCommand.Parameters["@return"].Value.ToString());2.获取Output输出参数值//存储过程//Create PROCEDURE MYSQL//@a int,//@b int,//@c int output//AS//Set @c = @a + @b//GOSqlConnection conn=newSqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());
conn.Open();
SqlCommand MyCommand=newSqlCommand("MYSQL", conn);
MyCommand.CommandType=CommandType.StoredProcedure;
MyCommand.Parameters.Add(newSqlParameter("@a", SqlDbType.Int));
MyCommand.Parameters["@a"].Value=20;
MyCommand.Parameters.Add(newSqlParameter("@b", SqlDbType.Int));
MyCommand.Parameters["@b"].Value=20;
MyCommand.Parameters.Add(newSqlParameter("@c", SqlDbType.Int));
MyCommand.Parameters["@c"].Direction=ParameterDirection.Output;
MyCommand.ExecuteNonQuery();
Response.Write(MyCommand.Parameters["@c"].Value.ToString());
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/mngzilin/archive/2010/01/09/5162859.aspx