DataList查询后分页

weixin_44376592

于 2019-05-02 09:45:13 发布

阅读量240

点赞数

本文链接：https://blog.csdn.net/weixin_44376592/article/details/89742716

版权

前台代码

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
    <style>
        * {
        box-sizing:border-box;
        }
        .item {
        display:inline-block;
        width:300px;
       
       width: 300px;
       overflow: hidden;
       white-space: nowrap;
       text-overflow: ellipsis;
        }
       

    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <div>
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <asp:Button ID="Button1" runat="server" Text="检索" OnClick="Button1_Click"  />
        </div>
        <div style="height:355px">
            <asp:DataList ID="DataList1" runat="server" CellPadding="4" ForeColor="#333333" AllowPaging="True">
                <AlternatingItemStyle BackColor="White"></AlternatingItemStyle>

                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White"></FooterStyle>

                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White"></HeaderStyle>

                <ItemStyle BackColor="#E3EAEB"></ItemStyle>
                <ItemTemplate>
                    <div style="width:620px">
                                              
                        <span class="item ">
                          <asp:Label ID="Label1" runat="server" Text=' <%# Eval("GG_title")%> '></asp:Label>
                        </span>
                        <span class="item" style="text-align:right">
                             <asp:Label ID="Label2" runat="server" Text='<%# Eval("GG_date")%> '></asp:Label>
                        </span>
                           
                    </div>
                </ItemTemplate>
                <SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333"></SelectedItemStyle>
                     
            </asp:DataList>
            </div>
           <table style="width: 620px; " > 
           <tr> 
           <td style="width:620px; text-align:center; font-size:12pt; height:25px;"> 
           <asp:Label ID="Label7" runat="server" Text="当前页码为："></asp:Label> 
           [ 
           <asp:Label ID="labPage" runat="server" Text="1"></asp:Label> 
           ] 
           <asp:Label ID="Label6" runat="server" Text="总页码为："></asp:Label> 
           [ 
           <asp:Label ID="labBackPage" runat="server"></asp:Label> 
           ]
          <asp:LinkButton ID="lnkbtnOne" runat="server" Font-Underline="False" ForeColor="Red" 
           OnClick="lnkbtnOne_Click">第一页</asp:LinkButton> 
          <asp:LinkButton ID="lnkbtnUp" runat="server" Font-Underline="False" ForeColor="Red" 
           OnClick="lnkbtnUp_Click">上一页</asp:LinkButton> 
          <asp:LinkButton ID="lnkbtnNext" runat="server" Font-Underline="False" ForeColor="Red" 
           OnClick="lnkbtnNext_Click">下一页</asp:LinkButton>  
          <asp:LinkButton ID="lnkbtnBack" runat="server" Font-Underline="False" ForeColor="Red" 
          OnClick="lnkbtnBack_Click">最后一页</asp:LinkButton>  </td> 
          </tr> 
          </table> 
    
    </div>
    </form>
</body>
</html>

后台代码

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class GerenCenterGonggaoList : System.Web.UI.Page
{
   

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["search"] = null;
            dlBind();
        }
    }
    public void dlBind()
    {
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);
        sqlcon.Open();
        SqlDataAdapter adsa = new SqlDataAdapter("select GG_title,GG_date from GongGao   order by ID desc", sqlcon);      
        int curpage = Convert.ToInt32(this.labPage.Text);
        PagedDataSource ps = new PagedDataSource();       
        DataSet ds = new DataSet();
        adsa.Fill(ds, "GongGao");
        ps.DataSource = ds.Tables["GongGao"].DefaultView;
        ps.AllowPaging = true; //是否可以分页 
        ps.PageSize = 10; //显示的数量 
        ps.CurrentPageIndex = curpage - 1; //取得当前页的页码 
        this.lnkbtnUp.Enabled = true;
        this.lnkbtnNext.Enabled = true;
        this.lnkbtnBack.Enabled = true;
        this.lnkbtnOne.Enabled = true;
        if (curpage == 1)
        {
            this.lnkbtnOne.Enabled = false;//不显示第一页按钮 
            this.lnkbtnUp.Enabled = false;//不显示上一页按钮 
        }
        if (curpage == ps.PageCount)
        {
            this.lnkbtnNext.Enabled = false;//不显示下一页 
            this.lnkbtnBack.Enabled = false;//不显示最后一页 
        }
        this.labBackPage.Text = Convert.ToString(ps.PageCount);
        this.DataList1.DataSource = ps;      
        this.DataList1.DataBind();
        sqlcon.Close();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text == "")
        {
            Response.Redirect("GerenCenterGonggaoList.aspx");
        }
        else
        {
            ViewState["search"] = 1;
            this.labPage.Text = "1"; //查询后从第一页开始显示
            LoadSearch(TextBox1.Text);
        }
    }
    protected void LoadSearch(string search)  //查询语句
    {
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);
        sqlcon.Open();
        SqlDataAdapter adsa = new SqlDataAdapter("select GG_title,GG_date from GongGao where GG_title like '%"+search+"%' order by ID desc", sqlcon);
        int curpage = Convert.ToInt32(this.labPage.Text);
        PagedDataSource ps = new PagedDataSource();
        DataSet ds = new DataSet();
        adsa.Fill(ds, "GongGao");
        ps.DataSource = ds.Tables["GongGao"].DefaultView;
        ps.AllowPaging = true; //是否可以分页 
        ps.PageSize = 10; //显示的数量 
        ps.CurrentPageIndex = curpage - 1; //取得当前页的页码 
        this.lnkbtnUp.Enabled = true;
        this.lnkbtnNext.Enabled = true;
        this.lnkbtnBack.Enabled = true;
        this.lnkbtnOne.Enabled = true;
        if (curpage == 1)
        {
            this.lnkbtnOne.Enabled = false;//不显示第一页按钮 
            this.lnkbtnUp.Enabled = false;//不显示上一页按钮 
        }
        if (curpage == ps.PageCount)
        {
            this.lnkbtnNext.Enabled = false;//不显示下一页 
            this.lnkbtnBack.Enabled = false;//不显示最后一页 
        }
        this.labBackPage.Text = Convert.ToString(ps.PageCount);
        this.DataList1.DataSource = ps;
        this.DataList1.DataBind();
        sqlcon.Close();

    }


    protected void lnkbtnOne_Click(object sender, EventArgs e)
    {
        this.labPage.Text = "1";
        if (ViewState["search"] == null)
        {
            this.dlBind();//加载全部
        }
        else
        {
            LoadSearch(TextBox1.Text);
        }
        
    }
    protected void lnkbtnUp_Click(object sender, EventArgs e)
    {
        this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) - 1);
        if (ViewState["search"] == null)
        {
            this.dlBind();//加载全部
        }
        else
        {
            LoadSearch(TextBox1.Text);
        }
    }
    protected void lnkbtnNext_Click(object sender, EventArgs e)
    {
        this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) + 1);
        if (ViewState["search"] == null)
        {
            this.dlBind();//加载全部
        }
        else
        {
            LoadSearch(TextBox1.Text);
        }
    }
    protected void lnkbtnBack_Click(object sender, EventArgs e)
    {
        this.labPage.Text = this.labBackPage.Text;
        if (ViewState["search"] == null)
        {
            this.dlBind();//加载全部
        }
        else
        {
            LoadSearch(TextBox1.Text);
        }
    }

   
}

自行修改数据库连接和查询语句即可

weixin_44376592

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
DataList查询后分页

前台代码<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GerenCenterGonggaoList.aspx.cs" Inherits="GerenCenterGonggaoList" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/x...
复制链接

扫一扫