title: SQL Server stored procedure result returned
body: <p>I have a stored procedure in SQL Server :</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[GET_AVAILABLE_PLACES] 
  -- Add the parameters for the stored procedure here
  @eventGuid uniqueidentifier,
  @placeGuid uniqueidentifier,     
  @dateGuid dateTime 
  AS
  BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;
  -- Insert statements for procedure here
  DECLARE @ReservedPlaces int;
  DECLARE @TotalPlaces int;    
  SELECT @ReservedPlaces = RESERVED_PLACES FROM dbo.EVENT_DATE_PLACE
  WHERE EVENT_GUID = @eventGuid 
  and DATE_BEGIN = @dateGuid
  and PLACE_GUID = @placeGuid    
  SELECT @TotalPlaces = NUMBER_PLACES FROM dbo.PLACES
  WHERE GUID = @placeGuid    
  RETURN @TotalPlaces - @ReservedPlaces;     
  END
  </code></pre>
  
  <p>But I can not seem to read the result returned </p>
  
  <pre><code>private int SelectByStoredProcedureGetAvailablePlaces(string entryParam1, string entryParam2, DateTime entryParam3)
  {
          int results;
          //PlanningElement plan = GetPlanningElement(entryParam1, entryParam2, entryParam3.ToString(), "31/12/2012 00:00:00", "150");
  
          using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
          {
              SqlCommand sqlCommand = new SqlCommand();
              sqlCommand.Connection = sqlConnection;
  
              sqlCommand.CommandText = "GET_AVAILABLE_PLACES";
              sqlCommand.CommandType = CommandType.StoredProcedure;
              sqlCommand.Parameters.AddWithValue("eventGuid", entryParam1);
              sqlCommand.Parameters.AddWithValue("placeGuid", entryParam2);                
              sqlCommand.Parameters.AddWithValue("dateGuid", entryParam3);
  
              sqlConnection.Open();
  
              SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
              results = sqlDataReader.GetInt32(0);
  
              sqlConnection.Close();
          }
  
          return results;
      }
  </code></pre>
  
  <p>What is the problem ?</p>
  
  <p>Thanks</p>