使用VisualVB.NET對DataGridWindows控件執(zhí)行分頁

字號:

Imports System.Data
    Public Class test
    #Region "成員變量"
    Private dtSource As DataTable
    Private PageCount As Integer
    Private maxRec As Integer
    Private pageSize As Integer
    Private currentPage As Integer
    Private recNo As Integer
    #End Region
    Private Sub LoadPage()
    Try
    Dim i As Integer
    Dim startRec As Integer
    Dim endRec As Integer
    Dim dtTemp As DataTable
    ’Clone the source table to create a temporary table.
    dtTemp = dtSource.Clone()
    If currentPage = PageCount Then
    endRec = maxRec
    Else
    endRec = pageSize * currentPage
    End If
    startRec = recNo
    For i = startRec To endRec - 1
    ’Copy rows from the source table to fill the temporary table.
    dtTemp.ImportRow(dtSource.Rows(i))
    recNo += 1
    Next
    Me.DataGridView1.DataSource = dtTemp
    DisplayPageInfo()
    Catch ex As Exception
    End Try
    End Sub