向杨涛 (用户名:webdiyer)提问,关于UrlPager1.0版存储过程问题

qq22345111 qq22345111 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
杨老师,这贴是关于UrlPager1.0实现存储过程分页问题!
问题描述:我在同一个页面,配置好Global.asax与webConfig以后,调用您提供的存储过程可以让UrlPager1.0在页面显示并分页,我仿照你提供的存储过程,自己编写了一个,能够实现数据绑定,但是页面空间无法显示!我将存储过程提供如下
您的存储过程:P_GetOrderNumber
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[P_GetOrderNumber]
AS
select count(orderid) from orders;
RETURN

我仿照写的:P_GetAllergyType
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[P_GetAllergyType]
AS
select count(gmxxlx_id) from b_gmxxlx;
return

您的存储过程:P_GetPagedOrders2000
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[P_GetPagedOrders2000]
(@startIndex int,
@endIndex int
)
as
set nocount on
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select orderid from orders order by orderid desc
select O.orderid,O.orderdate,O.customerid,C.CompanyName,E.FirstName+' '+E.LastName as EmployeeName

from orders O
left outer join Customers C
on O.CustomerID=C.CustomerID
left outer join Employees E
on O.EmployeeID=E.EmployeeID
inner join @indextable t on
O.orderid=t.nid
where t.id between @startIndex and @endIndex order by t.id
set nocount off
RETURN

我的存储过程:P_GetPagedAllergyType
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create PROCEDURE [dbo].[P_GetPagedAllergyType]
(@startIndex int,
@endIndex int)
AS
SET NOCOUNT ON
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) select gmxxlx_id from b_gmxxlx order by gmxxlx_id desc
select O.gmxxlx_id,O.gmxxlx_bm,O.gmxxlx_mc,O.bz from b_gmxxlx O
inner join @indextable t on O.gmxxlx_id=t.nid
where t.id between @startIndex and @endIndex order by t.id
set nocount off
RETURN
...全文

相关推荐

评论 3
收藏 已收藏
分享
返回顶部
qq22345111
.NET社区 62,275 成员 668,968 内容