Asp.net paging SQL statements and stored procedures

SQL statement:

Use not in select top pagesize * from table where TID not in (select top (pageIndex-1) * pagesize TID from Table Name); ------------ or select * from (select *, row_number () over (order by ID) rownumber from Table Name) t where T. rownumber> = 2 and T. rownumber <= 10;

Stored Procedure:

Create procedure getpagedata (@ pageindex Int = 1, @ pagesize Int = 10, @ rowcount int output, @ pagecount int output,) as declare @ SQL nvarchar (225 ), @ sqlcount nuachar (225) Select @ rowcount = count (SID), @ pagecount = ceiling (count (SID) + 0.0) /@ pagesize from studentsset @ SQL = 'select top '+ STR (@ pagesize) +' * from students, classes where SCID = CID and sid not in (select top) '+ STR (@ pageindex)-1) * pagesize) + 'sid from students 'print @ SQL exec (@ SQL) -- execute declare @ rowcount int, @ pagecount int exec getpagedata 1, 3, @ rowcount out, @ pagecount outputselect rowcount, @ pagecount