C # obtain the Return value and Output parameter value of a stored procedure

1. Get Return Value

 Program code

// Stored Procedure
// Create PROCEDURE MYSQL
// @ A int,
// @ B int
//
// Return @ a + @ B
// GO
SqlConnection conn = new SqlConnection (ConfigurationManager. ConnectionStrings ["LocalSqlServer"]. ToString ());
Conn. Open ();
SqlCommand MyCommand = new SqlCommand ("MYSQL", conn );
MyCommand. CommandType = CommandType. StoredProcedure;
MyCommand. Parameters. Add (new SqlParameter ("@ a", SqlDbType. Int ));
MyCommand. Parameters ["@ a"]. Value = 10;
MyCommand. Parameters. Add (new SqlParameter ("@ B", SqlDbType. Int ));
MyCommand. Parameters ["@ B"]. Value = 20;
MyCommand. Parameters. Add (new SqlParameter ("@ return", SqlDbType. Int ));
MyCommand. Parameters ["@ return"]. Direction = ParameterDirection. ReturnValue;
MyCommand. ExecuteNonQuery ();
Response. Write (MyCommand. Parameters ["@ return"]. Value. ToString ());

2. Get Output parameter values

Program code

// Stored Procedure
// Create PROCEDURE MYSQL
// @ A int,
// @ B int,
// @ C int output
//
// Set @ c = @ a + @ B
// GO
SqlConnection conn = new SqlConnection (ConfigurationManager. ConnectionStrings ["LocalSqlServer"]. ToString ());
Conn. Open ();
SqlCommand MyCommand = new SqlCommand ("MYSQL", conn );
MyCommand. CommandType = CommandType. StoredProcedure;
MyCommand. Parameters. Add (new SqlParameter ("@ a", SqlDbType. Int ));
MyCommand. Parameters ["@ a"]. Value = 20;
MyCommand. Parameters. Add (new SqlParameter ("@ B", SqlDbType. Int ));
MyCommand. Parameters ["@ B"]. Value = 20;
MyCommand. Parameters. Add (new SqlParameter ("@ c", SqlDbType. Int ));
MyCommand. Parameters ["@ c"]. Direction = ParameterDirection. Output;
MyCommand. ExecuteNonQuery ();
Response. Write (MyCommand. Parameters ["@ c"]. Value. ToString ());

 

Bytes ---------------------------------------------------------------------------------------------------------------

The following code