ASPNETPAGER應用

最新推荐文章于 2025-07-13 17:10:18 发布

wizardlun

最新推荐文章于 2025-07-13 17:10:18 发布

阅读量614

点赞数

文章标签： dataset server assembly string textbox sql

本文介绍了一个ASP.NET分页控件的具体实现方法，包括如何设置每页显示记录数、如何与数据库交互获取数据并展示，以及如何响应页面跳转事件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testaspnetpager.aspx.cs" Inherits="testaspnetpager" %>

<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>測試分頁控件</title>
</head>
<body>
    <form id="form1" runat="server">
         <asp:GridView ID="GridView1" runat="server" PageSize="3">
    </asp:GridView>

         <webdiyer:AspNetPager ID="AspNetPager2" runat="server" AlwaysShow="True"
             onpagechanging="AspNetPager2_PageChanging" PageIndexBoxType="TextBox"
             PageSize="3" ShowNavigationToolTip="True" ShowPageIndexBox="Always">
         </webdiyer:AspNetPager>

    </form>
</body>
</html>

================================================================

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OracleClient;
using Wuqi.Webdiyer;
using System.Data.OleDb;

public partial class testaspnetpager : System.Web.UI.Page
{
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["OracleConnectionString"].ToString();
OracleConnection conn = new OracleConnection();

    public OracleConnection getconnect()
    {
        conn = new OracleConnection(constr);
        return conn;
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sql = "SELECT * FROM TEST1";
            OracleDataAdapter oda1 = new OracleDataAdapter(sql, getconnect());
            DataSet ds1 = new DataSet();
            oda1.Fill(ds1);
            this.AspNetPager2.RecordCount = ds1.Tables[0].Rows.Count;
            bind();

}

    public void bind()
    {
        string sql = "SELECT * FROM TEST1";
        OracleDataAdapter oda = new OracleDataAdapter(sql,getconnect());
        DataSet ds = new DataSet();
        oda.Fill(ds,this.AspNetPager2.PageSize*(this.AspNetPager2.CurrentPageIndex-1),this.AspNetPager2.PageSize,"aaa");
        GridView1.DataSource = ds.Tables["aaa"];
        GridView1.DataBind();
    }

    protected void AspNetPager2_PageChanging(object src, PageChangingEventArgs e)
    {
        AspNetPager2.CurrentPageIndex = e.NewPageIndex;
        bind();
    }
}

注:若程序需導入至Excel,則需要特別注意.