asp.net 數(shù)據(jù)訪問層 存儲(chǔ)過程分頁(yè)語(yǔ)句

注:@pageindex 數(shù)據(jù)頁(yè)的索引,@dataperpage 每頁(yè)的記錄數(shù)目,@howmanyrecords 用來(lái)獲取總的記錄數(shù).
代碼如下:

create proc getdata @pageindex int,@dataperpage int,@howmanyrecords int output 
as 
declare @temptable table 
( 
rowindex int, 
emp_id char(9), 
fname varchar(20), 
minit char(1), 
lname varchar(30) 
) 
insert into @temptable 
select row_number() over(order by emp_id) as rowindex,emp_id,fname,minit,lname 
from employee 
select @howmanyrecords=count(rowindex) from @temptable 
select * from @temptable 
where rowindex>(@pageindex-1)*@dataperpage 
and rowindex<=@pageindex*@dataperpage 
declare @howmanyrecords int 
exec getdata 2,5,@howmanyrecords output 
select @howmanyrecords 
declare @x int, @y int, @z int 
select @x = 1, @y = 2, @z=3 
select @x,@y,@z 
create proc getdata2 @pageindex int,@dataperpage int,@howmanyrecords int output 
as 
declare @temptable table 
( 
rowindex int, 
emp_id char(9), 
fname varchar(20), 
minit char(1), 
lname varchar(30) 
) 
insert into @temptable 
select row_number() over(order by emp_id) as rowindex,emp_id,fname,minit,lname 
from employee 
select @howmanyrecords=count(rowindex) from @temptable 
select * from @temptable 
where rowindex>(@pageindex-1)*@dataperpage 
and rowindex<=@pageindex*@dataperpage 
 
其中Row_number 函數(shù)可以給檢索來(lái)的每條記錄按照排序來(lái)編號(hào). 
接下來(lái)你就可以在asp.net 網(wǎng)頁(yè)后臺(tái)代碼中調(diào)用該存儲(chǔ)過程,就可以獲取想要的數(shù)據(jù).
 
 




聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com