Imports System.Data.OleDb Imports System.Data PublicClass WebForm1Class WebForm1 Inherits System.Web.UI.Page Dim connection As OleDbConnection Const TNAME ="test" Const dbname ="testmdb.mdb" ProtectedWithEvents AjaxPanel1 As MagicAjax.UI.Controls.AjaxPanel ProtectedWithEvents Repeater1 As System.Web.UI.WebControls.Repeater ProtectedWithEvents nowpage As System.Web.UI.WebControls.Label ProtectedWithEvents totalpage As System.Web.UI.WebControls.Label ProtectedWithEvents totalrecord As System.Web.UI.WebControls.Label ProtectedWithEvents L_page As System.Web.UI.WebControls.Label ProtectedWithEvents linkf As System.Web.UI.WebControls.LinkButton ProtectedWithEvents Linkp As System.Web.UI.WebControls.LinkButton ProtectedWithEvents Linkn As System.Web.UI.WebControls.LinkButton ProtectedWithEvents Linkl As System.Web.UI.WebControls.LinkButton ProtectedWithEvents go1 As System.Web.UI.WebControls.TextBox ProtectedWithEvents Lgo As System.Web.UI.WebControls.LinkButton ProtectedWithEvents Ajaxpanel2 As MagicAjax.UI.Controls.AjaxPanel Dim _PageCount AsInteger Dim _TotalCount AsInteger Web 窗体设计器生成的代码#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。 <System.Diagnostics.DebuggerStepThrough()>PrivateSub InitializeComponent()Sub InitializeComponent() End Sub '注意: 以下占位符声明是 Web 窗体设计器所必需的。 '不要删除或移动它。 Private designerPlaceholderDeclaration As System.Object PrivateSub Page_Init()Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Init 'CODEGEN: 此方法调用是 Web 窗体设计器所必需的 '不要使用代码编辑器修改它。 InitializeComponent() End Sub #End Region PrivateSub Page_Load()Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load '在此处放置初始化页的用户代码 BindRepeater(5, 1) nowpage.Text =1 pageset() End Sub 有关数据库连接与操作#Region "有关数据库连接与操作 " PrivateSub conn()Sub conn() '新建一个连接 Dim ConnectString AsString ConnectString ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="& Server.MapPath(dbname) '连接ORACLE的字符串 connection =New OleDbConnection(ConnectString) '新建一个连接 End Sub PrivateSub openconn()Sub openconn() '打开连接 connection.Open() End Sub PrivateSub closeconn()Sub closeconn() '关闭连接 connection.Close() End Sub PrivateSub BindRepeater()Sub BindRepeater(ByVal pagesize AsInteger, ByVal currentpage AsInteger) Dim sql AsString sql ="select id,text from "& TNAME conn() openconn() Repeater1.DataSource = getdatasource(sql, pagesize, currentpage) Repeater1.DataBind() closeconn() End Sub PrivateFunction getdatasource()Function getdatasource(ByVal sql AsString, ByVal pagesize AsInteger, ByVal curentpage AsInteger) '用来获得要显示数据的视图 Dim ds As DataSet Dim objPds As PagedDataSource Dim adapter As OleDbDataAdapter ds =New DataSet objPds =New PagedDataSource adapter =New OleDbDataAdapter(sql, connection) adapter.Fill(ds, "Table") objPds.DataSource = ds.Tables(0).DefaultView() objPds.AllowPaging =True objPds.PageSize = pagesize _PageCount = objPds.PageCount _TotalCount = ds.Tables(0).DefaultView().Count objPds.CurrentPageIndex = curentpage Return objPds End Function #End Region 翻页#Region "翻页" PrivateSub pageset()Sub pageset() If nowpage.Text ="1"Then linkf.Enabled =False Linkp.Enabled =False Else linkf.Enabled =True Linkp.Enabled =True EndIf If nowpage.Text = _PageCount Then Linkl.Enabled =False Linkn.Enabled =False Else Linkl.Enabled =True Linkn.Enabled =True EndIf totalpage.Text = _PageCount totalrecord.Text = _TotalCount If _TotalCount =0Then nowpage.Text ="0" EndIf L_page.Text ="第 <FONT color='red'>"+ nowpage.Text +"</font> 页/共 "+ totalpage.Text +" 页,总计 "+ totalrecord.Text +" 条" End Sub PrivateSub linkf_Click()Sub linkf_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles linkf.Click Session("curent") =0 BindRepeater(5, Session("curent")) Linkp.Enabled =False nowpage.Text ="1" pageset() End Sub PrivateSub Linkl_Click()Sub Linkl_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles Linkl.Click Session("curent") = _PageCount -1 BindRepeater(5, Session("curent")) Linkn.Enabled =False nowpage.Text = Session("curent") +1 pageset() End Sub PrivateSub Linkn_Click()Sub Linkn_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles Linkn.Click Session("curent") = Session("curent") +1 BindRepeater(5, Session("curent")) nowpage.Text = Session("curent") +1 pageset() End Sub PrivateSub Linkp_Click()Sub Linkp_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles Linkp.Click Session("curent") = Session("curent") -1 BindRepeater(5, Session("curent")) nowpage.Text = Session("curent") +1 pageset() End Sub PrivateSub Lgo_Click()Sub Lgo_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles Lgo.Click Dim go AsInteger IfIsNumeric(Trim(go1.Text)) Then If (Int(Trim(go1.Text)) >0) And (Int(Trim(go1.Text)) < _PageCount) Then go =Int(Trim(go1.Text)) Session("curent") = go -1 BindRepeater(5, Session("curent")) nowpage.Text = Session("curent") +1 pageset() EndIf EndIf End Sub #End Region End Class