我已经用存储过程 实现 了 分页 和绑定 并能控制它每页的显示数目存储过程如下:(不是我写的 所以不会用) 别人告诉我说用个什么控件 再把下面的 一个值拿来计算分页,我不太明白 大家给我讲讲CREATE procedure P_GetUserListByType
(@SelectType Int =0,
@pagesize int = 12,
@pageindex int =1 ,
@docount bit = 0
)
as
set nocount on
if(@docount=1)
select count(UserID) from P_UserInfo
else
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
if @SelectType = 0
insert into @indextable(nid) select UserID from P_UserInfo order by UserID desc
if @SelectType = 1
insert into @indextable(nid) select UserID from P_UserInfo order by VoteNum desc, UserID desc
if @SelectType = 2
insert into @indextable(nid) select UserID from P_UserInfo order by ReNum desc, UserID desc
select O.* from P_UserInfo O,@indextable t where O.UserID=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO
(@SelectType Int =0,
@pagesize int = 12,
@pageindex int =1 ,
@docount bit = 0
)
as
set nocount on
if(@docount=1)
select count(UserID) from P_UserInfo
else
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
if @SelectType = 0
insert into @indextable(nid) select UserID from P_UserInfo order by UserID desc
if @SelectType = 1
insert into @indextable(nid) select UserID from P_UserInfo order by VoteNum desc, UserID desc
if @SelectType = 2
insert into @indextable(nid) select UserID from P_UserInfo order by ReNum desc, UserID desc
select O.* from P_UserInfo O,@indextable t where O.UserID=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO
解决方案 »
- VS2005如何显示Access Modifier?
- aspx页面显示问题
- 操作两个TXT文件,并取出数据存入数据库的难题!!!比较复杂,麻烦大家帮忙(UP有分!)
- 关于一个javascript的问题,急,大家来看看
- ASP.NET WEB自定义控件属性显示问题求助--->>
- 麻烦各位给看看?
- vs.net做asp.net项目安装程序,如何在桌面上创建一个指向首页的快捷方式页面
- 再次提问:我的数据不能连接问题,也不知道自己到底有没有连接上
- 寻求一种类似SmartGrid的免费控件
- 关于多层架构,引用后再继承的问题
- 如何将一张图片上传之后自动压缩显示出来(急!!!)在线等!!
- 关于GirdView点击跳转后设置的参数引用的问题????跪求
http://webprince.spaces.msn.com/Blog/cns!1pINGEv1GXprVRQWKI04Wy5g!407.entry
这个跟DATALIST无关的,设置控件的样式就OK