求解ASPNETPAGER分页控件的存储过程的解释!
create procedure DEMO
(@pagesize int,
@pageindex int,
@docount bit)
as
if(@docount=1)
select count(*) from TEST
else
begin
with temptbl as (
SELECT ROW_NUMBER() OVER (ORDER BY ID asc)AS Row, * from TEST O )
SELECT * FROM temptbl where Row between (@pageindex-1)*@pagesize+1 and (@pageindex-1)*@pagesize+@pagesize
end
从这个网页生成的不知道代码的含义。http://www.webdiyer.com/Controls/AspNetPager/SpGenerator 谢了!