Asp.net DataList 分页代码

最新推荐文章于 2021-06-09 19:54:59 发布

lzid2008

最新推荐文章于 2021-06-09 19:54:59 发布

阅读量1.3k

点赞数 1

分类专栏： .Net 2.0 文章标签： asp.net hyperlink dataset server asp xhtml

本文链接：https://blog.csdn.net/lzid2008/article/details/3248272

版权

.Net 2.0 专栏收录该内容

56 篇文章 1 订阅

订阅专栏

using System;
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.OleDb;

public partial class news : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

        string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        OleDbConnection objConnection = new OleDbConnection(strConnection);
        objConnection.Open();

        string strsql = "select * from news order by news_ID desc";
        OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strsql, objConnection);
        //建立DataSet对象ds;利用Adapter的Fill方法把SQL命令执行的结果倒入DataSet对象
        DataSet ds = new DataSet();
        MyAdapter.Fill(ds, "news");

        objConnection.Close();

        //分页开始 -------
        int CurPage;
        if (Request.QueryString["Page"] != null && Convert.ToInt32(Request.QueryString["Page"]) > 0)
            CurPage = Convert.ToInt32(Request.QueryString["Page"]);
        else
            CurPage = 1;

        PagedDataSource ps = new PagedDataSource();
        ps.DataSource = ds.Tables["news"].DefaultView;
        ps.AllowPaging = true;
        //每个页面显示的条数
        ps.PageSize = 10;
        onePage.Text = ps.PageSize.ToString();
        //求数据的总数
        allMsg.Text = ps.DataSourceCount.ToString();
        ps.CurrentPageIndex = CurPage - 1;
        //求总页
        allPages.Text = ps.PageCount.ToString();
        nowPage.Text = CurPage.ToString();
        //将数据源与控件绑定
        newsList.DataSource = ps;
        newsList.DataBind();

        //上一页
        if (!ps.IsFirstPage)
        {
            firstPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
            prePage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
        }
        //下一页
        if (!ps.IsLastPage)
        {
            nextPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
            endPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(ps.PageCount);
        }
        //分页结束 -------

}
}
==========

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="news" %>
<%@ Import Namespace="System.Data" %>
<%@ Register Src="inc/top.ascx" TagName="top" TagPrefix="uc1" %>
<%@ Register Src="inc/foot.ascx" TagName="foot" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

                        </td>
                    </tr>
                </table>
            </ItemTemplate>

</asp:Repeater>
        
        <br />
        <div align="center">
            [页次:<asp:Label ID="nowPage" runat="server" Font-Bold="True"></asp:Label>/<asp:Label ID="allPages" runat="server" Font-Bold="True" ForeColor="#C00000"></asp:Label>]
            [共<asp:Label ID="allMsg" runat="server" Font-Bold="True"></asp:Label>条
            <asp:Label ID="onePage" runat="server" Font-Bold="True"></asp:Label>条/页]

            [<asp:HyperLink ID="firstPage" runat="server">首页</asp:HyperLink>]
            [<asp:HyperLink ID="prePage" runat="server">上一页</asp:HyperLink>]
            [<asp:HyperLink ID="nextPage" runat="server">下一页</asp:HyperLink>]
            [<asp:HyperLink ID="endPage" runat="server">尾页</asp:HyperLink>]
       </div>
       <br /><a href="admin/login.aspx">后台登录</a>
    </div>
    <uc2:foot ID="foot1" runat="server" />
    </form>
</body>