C#获取存储过程的Return返回值和Output输出参数值.doc

C#获取存储过程的Return返回值和Output输出参数值 1.获取Return返回值程序代码/存储过程/Create PROCEDURE MYSQL/ a int,/ b int/AS/ return a + b/GOSqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStringsLocalSqlServer.ToString();conn.Open();SqlCommand MyCommand = new SqlCommand(MYSQL, conn);MyCommand.CommandType = CommandType.StoredProcedure;MyCommand.Parameters.Add(new SqlParameter(a, SqlDbType.Int);MyCommand.Parametersa.Value = 10;MyCommand.Parameters.Add(new SqlParameter(b, SqlDbType.Int);MyCommand.Parametersb.Value = 20;MyCommand.Parameters.Add(new SqlParameter(return, SqlDbType.Int);MyCommand.Parametersreturn.Direction = ParameterDirection.ReturnValue;MyCommand.ExecuteNonQuery();Response.Write(MyCommand.Parametersreturn.Value.ToString();2.获取Output输出参数值程序代码/存储过程/Create PROCEDURE MYSQL/ a int,/ b int,/ c int output/AS/ Set c = a + b/GOSqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStringsLocalSqlServer.ToString();conn.Open();SqlCommand MyCommand = new SqlCommand(MYSQL, conn);MyCommand.CommandType = CommandType.StoredProcedure;MyCommand.Parameters.Add(new SqlParameter(a, SqlDbType.Int);MyCommand.Parametersa.Value = 20;MyCommand.Parameters.Add(new SqlParameter(b, SqlDbType.Int);MyCommand.Parametersb.Value = 20;MyCommand.Parameters.Add(new SqlParameter(c, SqlDbType.Int);MyCommand.Parametersc.Direction = ParameterDirection.Output;MyCommand.ExecuteNonQuery();Response.Write(MyCommand.Parametersc.Value.ToString();-以下代码转自网络：C#接收存储过程返回值: public static int User_Add(User us) int iRet; SqlConnection conn = new SqlConnection(Conn_Str); SqlCommand cmd = new SqlCommand(User_Add, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(UName, us.UName); cmd.Parameters.AddWithValue(UPass, us.UPass); cmd.Parameters.AddWithValue(PassQuestion, us.PassQuestion); cmd.Parameters.AddWithValue(PassKey, us.PassKey); cmd.Parameters.AddWithValue(Email, us.Email); cmd.Parameters.AddWithValue(RName, us.RName); cmd.Parameters.AddWithValue(Area, us.Area); cmd.Parameters.AddWithValue(Address, us.Address); cmd.Parameters.AddWithValue(ZipCodes, us.ZipCodes); cmd.Parameters.AddWithValue(Phone, us.Phone); cmd.Parameters.AddWithValue(QQ, us.QQ); cmd.Parameters.Add(RETURN_VALUE, ).Direction = ParameterDirection.ReturnValue; try conn.Open(); cmd.ExecuteNonQuery(); iRet = (int)cmd.ParametersRETURN_VALUE.Value; catch (SqlException ex) throw ex; finally conn.Close(); return iRet; C#接收存储过程输出参数: public static decimal Cart_UserAmount(int UID) decimal iRet; SqlConnection conn = new SqlConnection(Conn_Str); SqlCommand cmd = new SqlCommand(Cart_UserAmount, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(UID, UID); cmd.Parameters.Add(Amount, SqlDbType.Decimal).Direction=ParameterDirection.Output; try conn