Not Receiving Return Value

Hi there,

I am writing an SQL stored procedure that returns a dataset as well as
a return value.  When I execute the stored proc, all seems to
work, except the return value comes back as null.

Code:

            // Create Instance of Connection and Command Object
            SqlConnection
connection = new SqlConnection(ApplicationConfig.ConnectionString);
            SqlCommand
command = new SqlCommand("SoundLeaf_GetPagedProductsByCategory",
connection);

            // Mark the Command as a SPROC
            command.CommandType = CommandType.StoredProcedure;

            // Add Parameters to SPROC
            SqlParameter
parameterID = new SqlParameter("@CategoryID", SqlDbType.Int);
            parameterID.Value = categoryID;
            command.Parameters.Add(parameterID);

            SqlParameter
parameterPageIndex = new SqlParameter("@PageIndex", SqlDbType.Int);
            parameterPageIndex.Value = pageIndex;
            command.Parameters.Add(parameterPageIndex);

            SqlParameter
parameterRowCount = new SqlParameter("@RowCount", SqlDbType.Int);
            parameterRowCount.Value = rowCount;
            command.Parameters.Add(parameterRowCount);

            SqlParameter
parameterPageCount = new SqlParameter("@PageCount", SqlDbType.Int);
            parameterPageCount.Direction = ParameterDirection.Output;
            command.Parameters.Add(parameterPageCount);

            // Open the connection and execute the Command
           
connection.Open();       
           
   
            SqlDataReader
dr = command.ExecuteReader(CommandBehavior.CloseConnection);
            pageCount =
(int)command.Parameters["@PageCount"].Value; // Null Reference Exception
        }

SQL:

CREATE PROCEDURE GetPagedProductsByCategory]
(
    @CategoryId int = 0,
    @PageIndex int = 1,
    @RowCount int = 10,     
    @PageCount int OUTPUT
)
AS
    Declare @TotalRows int, @StartPosition int

    Declare @PK int
    DECLARE @tmpTable TABLE (
        PK int NOT NULL PRIMARY KEY
    )

    SELECT  @StartPosition = (((@PageIndex - 1) * @RowCount) + 1)   
   
    Set @TotalRows = @StartPosition + @RowCount   
   
    Set RowCount @TotalRows   

    DECLARE PagingCursor CURSOR DYNAMIC READ_ONLY FOR
        select a.ProductId
        from
            products a,
            categoryProducts b
        where
            b.categoryid = @CategoryID and
            b.productid = a.productid
        Order By a.productid
       
    Open PagingCursor
    Fetch Relative @StartPosition From PagingCursor Into @PK

    while (@RowCount <> 0) And (@@Fetch_Status = 0)
    begin
        Insert Into @tmpTable (PK)
        Values (@PK)

        Fetch Next From PagingCursor Into @PK
        Set @RowCount = @RowCount - 1
    end

    Close PagingCursor
    Deallocate PagingCursor

    Select Products.* From Products
    Join @tmpTable temp ON Products.ProductID = temp.PK
    Order By Products.ProductID   
   
    SELECT @PageCount = COUNT(*) / @RowCount FROM Products    // value is never returned

    Set RowCount 0   
GO

Any thoughts?

JR