asp.net DataGrid实现分页显示数据

 

代码：

其中：allowpageing属性为true；pagesize=3; pagestyle-mode=nextprev等

Imports System.Data
Imports System.Data.SqlClient
Public Class datagrid
Inherits System.Web.UI.Page

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Binddatasource()
    End Sub

    Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged

        DataGrid1.CurrentPageIndex = e.NewPageIndex

     Binddatasource()
    End Sub

    Function loaddataview() As DataView
        Dim str As String
        str = "server=(local);uid=sa;pwd=;database=lab"
        Dim con As SqlConnection
        con = New SqlConnection(str)
        Dim ds As DataSet
        Dim da As SqlDataAdapter
        da = New SqlDataAdapter("select * from test2", con)
        ds = New DataSet
        da.Fill(ds, "test2")
        loaddataview = New DataView(ds.Tables("test2"))

    End Function
    Sub Binddatasource()
        DataGrid1.DataSource = loaddataview()
        DataGrid1.DataBind()

    End Sub

End Class