Paging In SQL2000,help Needed Urgently

 Hi,

I urgently need help with this. I am trying to implement custom paging with Sql 2000. However I have ran into a few problems.
I really hope that someone would be able to help me out. I need to get this done by tomorrow!! (I know I screwed up big time, but I didn;t relize that built in paging fetches all the records, and the displays it page by page!!)

1) Currently the paging seems to be working. However the primary key always resets itself. For example, lets say I have 4 records ID 1,2,3,4
When I delete ID 3, instead of displaying ID 1,2,4 it shows ID 1,2,3. Is there any way to solve this problem?

2) The database that I am currently creating will have about 40,000 records, is it advisible for me to use your control (I hope so)?

Thank you and do have a nice day.


http://www.codeproject.com/aspnet/ASPNETPagerControl.asp    CREATE PROCEDURE [dbo].[GetPagedProducts11]
(
@PageSize int,
@CurrentPage int,
@ItemCount int output
)
AS
Declare @UpperBand int, @LowerBand int

-- Get The Count Of The Rows That They Meet the Criteria
SET @ItemCount = (SELECT COUNT(*) FROM aduan)

-- Calculate the @LowerCount and @UpperCount
SET @LowerBand = (@CurrentPage - 1) * @PageSize
SET @UpperBand = (@CurrentPage * @PageSize) + 1

-- create a temporaty table
CREATE TABLE #AllRows(
ad_id int PRIMARY KEY IDENTITY(1, 1),
ad_nama varchar(40),ad_tarikh datetime , ad_status varchar(30) ,ad_title varchar(100)
)

-- INSERT ALL THE Rows that meets the Criteria
INSERT INTO #AllRows
SELECT ad_nama,ad_tarikh, ad_status,ad_title
FROM aduan


-- AND finally select and return desired -Paged- Rows
SELECT ad_id, ad_nama, ad_tarikh, ad_status,ad_title
FROM #AllRows
WHERE ad_id > @LowerBand AND ad_id < @UpperBand


RETURN