C#

CREATE PROCEDURE dbo.Foo
  @StateCode AS CHAR(2),
  @OutVariable1 AS INT OUTPUT,
  @OutVariable2 AS INT OUTPUT
AS
BEGIN
  SET @OutVariable1 = 100
  SET @OutVariable2 = 150

  SELECT * FROM dbo.Persons WHERE State = @StateCode
END

string stateCode = "AL";
int outValue1 = 0;
int outValue2 = 0;

using (SqlConnection = new SqlConnection(connectionString)) {
    using (SqlCommand cmd = new SqlCommand("dbo.Foo") ) {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Paramaters.Add("@StateCode", SqlDbType.Char, 2) = stateCode;
        SqlParameter outValue1Param = cmd.Parameters.Add("@OutVariable1", SqlDbType.Int);
        SqlParameter outValue2Param = cmd.Parameters.Add("@OutVariable2", SqlDbType.Int);

        // Get Result Set
        using (DataReader dr = cmd.ExecuteReader()) {
            while ( dr.Read() ) {
                // Read datareader value
            }
        }

        // Get output values
        outValue1 = (int) outValue1Param.Value;
        outValue2 = (int) outValue2Param.Value;
    }
}

}<br />
<br />
Is there another way to do this?  Tried looking into a foreach loop, but that would not work.<br />
<br />
Thank you!!!

using ( SqlDataReader dr = cmd.executeReader() ) {
  while ( dr.Read() ) {
    // Read all row values here
  }
}

// Now you can read the output value
int ouputValue = (int) outParam.Value;

SqlDataReader dr = cmd.ExecuteReader();

while ( dr.Read() ) {
  // Read all row values here
}
dr.Close();

// Now you can read the output value
int ouputValue = (int) outParam.Value;