SqlConnection MySqlConnection = new SqlConnection("Connection String");
SqlCommand MySqlCommand = new SqlCommand("MySP", MySqlConnection);
MYSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter MySqlParameter = new SqlParameter("@Value1", SqlDbType.Int);
MYSqlCommand.Parameters.Add(MySqlParameter);
MYSqlCommand.Parameters.Add("@Value2", SqlDbType.Int);
MYSqlCommand.Parameters.Add("@Value2", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(MYSqlCommand);