autopaging.aspx

来自「asp.net经典案例资料」· ASPX 代码 · 共 71 行

ASPX

71 行

<%@ Page Debug="true" Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
  <head>
    <title>DataGrid的自动分页</title>
    <script language="C#" runat="server" >

    // This data container will be initialize when Page is loaded
    DataTable dataTable;

    public void Page_Load()
    {
      string dataSource = "Data Source=localhost;";
      string security = "user id=sa; password=;";
      string initialCatalog = "initial catalog=pubs;";
      string cnnString = dataSource + security + initialCatalog;
      SqlConnection connection = new SqlConnection(cnnString);

      string strSql = "select * from [authors]";
      SqlCommand command = new SqlCommand(strSql, connection);
      SqlDataAdapter adapter = new SqlDataAdapter();
      adapter.SelectCommand = command;
      dataTable = new DataTable();

      try
      {
        connection.Open();
        adapter.Fill(dataTable);
      }
      catch(SqlException e)
      {
        Response.Write(e.ToString());
        return;
      } 
      finally
      {
        connection.Close();
      }

      if(!IsPostBack)
      {
        grid1.DataSource = dataTable;
        grid1.DataBind();
      }
    }

    public void Grid_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
    {
      grid1.CurrentPageIndex = e.NewPageIndex;
      grid1.DataSource = dataTable;
      grid1.DataBind();
    }
    </script>
  </head>

  <body>
  <form id="form1" runat="server">
    <h3>DataGrid的自动分页</h3>
    <asp:DataGrid id="grid1" runat="server" AutoGenerateColumns="true"
       AllowPaging="true" OnPageIndexChanged="Grid_PageIndexChanged" >
        <HeaderStyle BackColor="lightblue" Font-Name="Arial" Font-Bold="true" />
        <ItemStyle BackColor="lightyellow"/>
        <PagerStyle Mode="NextPrev" HorizontalAlign="Right" 
           NextPageText="下一页" PrevPageText="上一页" />
    </asp:DataGrid>
  </form>
  </body>
</html>

autopaging.aspx - 源码说明

本页面展示了「asp.net经典案例资料」中的 autopaging.aspx 源码文件，采用 ASPX 编程语言编写，共 71 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与asp相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?