Clarification On DataReader

I want to create a DataList that shows products, which will be on
multiple pages. I have my stored proc to show paged results, which
contains a return value for more records.

I have found examples of coding the DataReader, defining all the
parameters etc, but what about the drag and drop SqlDataSource?? You
can select the DataSource Mode to be "DataReader". I can put select
parameters in, with input and my return value. I don't know how to then
access the return value, or output value if needed, from this? My
DataList references the SqlDataSource, but I don't know how to get the
return/output value out??? This is very frustrating, cause I can't find
any info about it anywhere. Always input parameters, but no output.

This is my current SqlDataSource...



<asp:SqlDataSource ID="SqlDataSource1" runat="server"
DataSourceMode="DataReader" ConnectionString="<%$
ConnectionStrings:Personal %>" SelectCommand="sp_PagedItems"
SelectCommandType="StoredProcedure">

        <SelectParameters>

           
<asp:QueryStringParameter Name="Page" QueryStringField="page" />

            <asp:Parameter Name="RecsPerPage" DefaultValue="10" />

           
<asp:QueryStringParameter Name="CategoryID" QueryStringField="cat"
/>

           
<asp:Parameter Name="RETURN_VALUE" Direction="ReturnValue" Size="1"
/>

        </SelectParameters>

    </asp:SqlDataSource>



If I take out the RETURN_VALUE Parameter, my results display in my data
list, but that's useless if I can't access the return value to
determine the remaining number of pages etc. Is my RETURN_VALUE
parameter wrong? How do I access that? My stored proc is shown below...



CREATE PROCEDURE sp_PagedItems

   (

    @Page int,

    @RecsPerPage int,

    @CategoryID int

   )

AS



-- We don't want to return the # of rows inserted

-- into our temporary table, so turn NOCOUNT ON

SET NOCOUNT ON





--Create a temporary table

CREATE TABLE #TempItems

(

   ID int IDENTITY,

   No varchar(100),

   Name varchar(100),

   SDescription varchar(500),

   Size varchar(10),

   ImageURL varchar(100)

)





-- Insert the rows from tblItems into the temp. table

INSERT INTO #TempItems (No, Name, SDescription, Size, ImageURL)

SELECT No, Name, SDescription, Size, ImageURL FROM Products WHERE CategoryID=@CategoryID



-- Find out the first and last record we want

DECLARE @FirstRec int, @LastRec int

SELECT @FirstRec = (@Page - 1) * @RecsPerPage

SELECT @LastRec = (@Page * @RecsPerPage + 1)



-- Now, return the set of paged records, plus, an indiciation of we

-- have more records or not!

SELECT *,

       MoreRecords =

   (

    SELECT COUNT(*)

    FROM #TempItems TI

    WHERE TI.ID >= @LastRec

   )

FROM #TempItems

WHERE ID > @FirstRec AND ID < @LastRec





-- Turn NOCOUNT back OFF

SET NOCOUNT OFF