GridView(RadGrid)和自定义分页
好吧,所以我试图让我的自定义分页在Telerik RadGrid上进行(类似于
asp:Gridview
),但我仍然在打墙。 (我的问题的第一部分在这里得到了回答)
所以我已经实施了这个建议。我使用以下存储过程
ALTER PROCEDURE [dbo].[bt_HealthMonitor_GetAll]
(
@StartRowIndex int,
@MaximumRows int
)
AS
SET NOCOUNT ON
Select
RowNum,
[ID],
[errEx],
[errURL],
[errSource],
[errUser],
[errMessage],
[errIP],
[errBrowser],
[errOS],
[errStack],
[errDate],
[errNotes]
From
(
Select
[ID],
[errEx],
[errURL],
[errSource],
[errUser],
[errMessage],
[errIP],
[errBrowser],
[errOS],
[errStack],
[errDate],
[errNotes],
Row_Number() Over(Order By [ID]) As RowNum
From dbo.[bt_HealthMonitor] t
)
As DerivedTableName
Where RowNum Between @StartRowIndex And (@StartRowIndex + @MaximumRows)
Order By [ID] Desc
然后另一个存储过程来获取记录计数
ALTER PROCEDURE [dbo].[bt_HealthMonitor_GetRecordCount]
AS
SET NOCOUNT ON
return (Select Count(ID) As TotalRecords From bt_HealthMonitor)
我正在使用LINQ to SQL绑定到我的RadGrid
Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs)
Dim startRowIndex As Integer = (RadGrid1.CurrentPageIndex * RadGrid1.PageSize)
Dim maximumRows As Integer = RadGrid1.PageSize
Dim HealthMonitorDC As New DAL.HealthMonitorDataContext
Dim r = HealthMonitorDC.bt_HealthMonitor_GetAll(startRowIndex, maximumRows)
RadGrid1.DataSource = r
End Sub
Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreInit
Dim HealthMonitorDC As New DAL.HealthMonitorDataContext
Dim count = HealthMonitorDC.bt_HealthMonitor_GetRecordCount()
RadGrid1.MasterTableView.VirtualItemCount = count.ReturnValue
RadGrid1.VirtualItemCount = count.ReturnValue
End Sub
但我遇到的问题是网格只抓取前10行(如预期的那样),但我需要得到它以便它会识别表中有200行,以便显示分页图标。
如果我使用下拉列表显示50条记录,那么50显示,但仍然没有分页图标让我到下一个50。
我究竟做错了什么?
没有找到相关结果
已邀请:
3 个回复
悲帽慑彤电
属性来完成的(您必须查询记录总数)。 有关详细信息,请查看文档页面或参阅自定义分页的在线演示。
田损比报
显然,如果您只是随时从数据库中检索记录,那么您将希望将此作为数据访问调用的一部分。
诧不达