gridview存储过程+分页1

CREATE PROCEDURE CunChuFenYe
(
@PageSize int,
@PageIndex int,
@Condition varchar(255),
@TheTable varchar(255),
@SelectField varchar(255),
@TableID varchar(255)
)
AS

begin
declare @Sql varchar(5000)
declare @numb int
declare @ll varchar(255)
set @numb=@PageSize*(@PageIndex-1)
set @ll=cast(@numb as varchar(255))
set @Sql='select top '+cast(@PageSize as varchar(255))+' '+@SelectField+' from '+@TheTable+@Condition+' where '+@TableID+' not in (select  
top '+@ll+' '+@TableID+' from '+@TheTable+@Condition+' '+') '
exec(@Sql)
set @Sql='select count('+@TableID+') from '+@TheTable+@Condition
exec(@Sql)
end
GO
--分页存储过程

CREATE PROC Common_Page
@RecordCount    INT,
@QueryStr     NVARCHAR(100)='table1',--表名、视图名、查询语句
@PageSize     INT = 20,        --每页的大小(行数)