Ajax 实现分页 【无刷新】三层 | GridView 实现分页【有刷新】

SQL

动软生成简单的三层

DECLARE @pagesize int;
declare @pageindex int;
select * from(select ROW_NUMBER() over(order by Id) as rownumber,* from T_News1)T 
WHERE rownumber>(@pageindex-1)*@pagesize AND rownumber<=@pageindex*@pagesize

GO
create proc pro_fenye
@pagesize int,
@pageindex int
as
select * from(select ROW_NUMBER() over(order by Id) as rownumber,* from T_News1)T 
WHERE rownumber>(@pageindex-1)*@pagesize AND rownumber<=@pageindex*@pagesize
GO

EXEC pro_fenye 5,2
DECLARE @pagesize in