有判断啊 没有出现你说的问题Private Sub cmdNext_Click() lCurrentPage = lCurrentPage + 1 Call Loadcontrol(lCurrentPage)End Sub Private Sub cmdPrevious_Click() If lCurrentPage > 1 Then lCurrentPage = lCurrentPage - 1 Call Loadcontrol(lCurrentPage)End IfEnd Sub
你可以自己试试你的代码,当数据不足一页的时候,就会报错的,所以我做了一下改动,改后的地方的代码如下: For lCount = 1 To nPageSize If Not (adoPrimaryRS.EOF Or adoPrimaryRS.BOF) Then objrs.AddNew objrs!PRIV_ID = adoPrimaryRS!PRIV_ID objrs!Priv_name = adoPrimaryRS!Priv_name objrs!Menu_name = adoPrimaryRS!Menu_name objrs!Menu_level = adoPrimaryRS!Menu_level objrs!Parent_menu = adoPrimaryRS!Parent_menu adoPrimaryRS.MoveNext Else GoTo L1 End If Next L1: '绑定 Set DataGrid1.DataSource = objrs '在文本框显示页数
没有出现你说的问题Private Sub cmdNext_Click() lCurrentPage = lCurrentPage + 1 Call Loadcontrol(lCurrentPage)End Sub
Private Sub cmdPrevious_Click() If lCurrentPage > 1 Then lCurrentPage = lCurrentPage - 1 Call Loadcontrol(lCurrentPage)End IfEnd Sub
For lCount = 1 To nPageSize
If Not (adoPrimaryRS.EOF Or adoPrimaryRS.BOF) Then
objrs.AddNew
objrs!PRIV_ID = adoPrimaryRS!PRIV_ID
objrs!Priv_name = adoPrimaryRS!Priv_name
objrs!Menu_name = adoPrimaryRS!Menu_name
objrs!Menu_level = adoPrimaryRS!Menu_level
objrs!Parent_menu = adoPrimaryRS!Parent_menu adoPrimaryRS.MoveNext
Else
GoTo L1
End If
Next
L1:
'绑定
Set DataGrid1.DataSource = objrs
'在文本框显示页数