vb.net 分页显示数据

Imports Microsoft.Office.Interop.Excel
Imports System.Windows.Forms
Imports System.IO
Imports MySql.Data.MySqlClient
Imports System.Data.OleDb
Imports System
Imports System.Data
Imports System.Reflection
Public Class Form1
    Dim MySqlConn As MySqlConnection
    Dim data As System.Data.DataTable
    Dim MySqlda As MySqlDataAdapter
    Dim MySqlcb As MySqlCommandBuilder
    Dim MySqldr As MySqlDataReader
    Dim datelong As Double
    Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, ByVal lpKeyName As String, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Int32, ByVal lpFileName As String) As Int32
    Dim connstr As String = String.Format()

    Dim dgvPage As Object
    Public Sub New()
        ' 此调用是 Windows 窗体设计器所必需的。
        InitializeComponent()
        ' 在 InitializeComponent() 调用之后添加任何初始化。
        '实例化分页类成员
        dgvPage = New ClsDataGridViewPage '分页类成员
    End Sub

    '读取员工资料 
    Private Sub 管理后台_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        读取员工()
        '获取需要分页显示的DataView
        Dim dt As System.Data.DataTable = Me.DataGridView1.DataSource
        dgvPage.SetDataView = dt.DefaultView
        dgvPage.Paging()
        Dim ss As String
        For j = 0 To DataGridView1.Rows.Count - 2 Step 1
            ss = DataGridView1.Item(2, j).Value.ToString()
            Dim sdate As Date
            sdate = CDate(ss)
            Dim kk As TimeSpan = System.DateTime.Now - sdate
            If kk.Days > 0 Then
                DataGridView1.Rows(j).DefaultCellStyle.BackColor = Color.Red
            Else
                DataGridView1.Rows(j).DefaultCellStyle.BackColor = Color.Green
            End If
        Next
    End Sub

    Private Sub Button首页_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        读取员工()
        '获取需要分页显示的DataView
        Dim dt As System.Data.DataTable = Me.DataGridView1.DataSource
        dgvPage.SetDataView = dt.DefaultView
        dgvPage.GoFirstPage()
        Dim ss As String
        For j = 0 To DataGridView1.Rows.Count - 2 Step 1
            ss = DataGridView1.Item(2, j).Value.ToString()
            Dim sdate As Date
            sdate = CDate(ss)
            Dim kk As TimeSpan = System.DateTime.Now - sdate
            If kk.Days > 0 Then
                DataGridView1.Rows(j).DefaultCellStyle.BackColor = Color.Red
            Else
                DataGridView1.Rows(j).DefaultCellStyle.BackColor = Color.Green
            End If
        Next
    End Sub

    Private Sub Button上一页_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        读取员工()
        '获取需要分页显示的DataView
        Dim dt As System.Data.DataTable = Me.DataGridView1.DataSource
        dgvPage.SetDataView = dt.DefaultView
        dgvPage.GoPrevPage()
        Dim ss As String
        For j = 0 To DataGridView1.Rows.Count - 2 Step 1
            ss = DataGridView1.Item(2, j).Value.ToString()
            Dim sdate As Date
            sdate = CDate(ss)
            Dim kk As TimeSpan = System.DateTime.Now - sdate
            If kk.Days > 0 Then
                DataGridView1.Rows(j).DefaultCellStyle.BackColor = Color.Red
            Else