datalist和repeater通用分页

最新推荐文章于 2013-08-07 11:31:00 发布

wangwang008

最新推荐文章于 2013-08-07 11:31:00 发布

阅读量454

点赞数

CC 4.0 BY-SA版权

分类专栏： asp.net petshop4项目文章标签： server asp border table 工具 url

本文链接：https://blog.youkuaiyun.com/wangwang008/article/details/3490060

asp.net 同时被 2 个专栏收录

54 篇文章

订阅专栏

petshop4项目

14 篇文章

订阅专栏

本文介绍了一个简单的分页控件实现方法，通过ASP.NET技术，实现了动态加载数据和页面跳转功能。具体包括获取总记录数、计算总页数、显示当前页数据等功能。

前台==============================

   <table cellspacing="1" cellpadding="1" width="100%" 
                  bgcolor="#999999" border="0" style="border-collapse:collapse;" >
                <tbody>
                  <tr align="center" bgcolor="#e0f0ff">
                    <td width="189" height="27"><strong>工具名称</strong></td>
                    <td width="285" align="center"><strong>说明</strong></td>
                    <td width="146"><div align="center"><strong>时间</strong></div></td>
                    <td width="49" align="center"><strong>下载</strong></td>
                  </tr>
                    <asp:Repeater ID="Repeater3" runat="server"> 
                    <ItemTemplate>
                      <tr align="center" bgcolor="#ffffff">
                    <td height="27" align="left"><%# Eval("name")%></td>
                    <td align="left"><%# Eval("js")%></td>
                    <td><div align="center">最新</div></td>
                    <td align="center"><a 
                        href='<%# Eval("url")%>'><img 
                        height="18" src="images/copy.gif" 
                        width="19" border="0" /></a></td>
                  </tr>
                    </ItemTemplate>
                    </asp:Repeater>
                  
                   
                
                          </tbody>
              </table>
<!--分页的按钮-->
<TABLE id="Table1" cellSpacing="0" borderColorDark="white" cellPadding="0" align="right"
        border="0" style="WIDTH: 637px; HEIGHT: 28px">
        <TR align="center">
         <TD noWrap width="10%">共
          <asp:label id="lblRecNum" runat="server"></asp:label>条记录</TD>
         <TD noWrap width="30%">第
          <asp:label id="lblCurPageNO" runat="server"></asp:label>页/共
          <asp:label id="lblPageNum" runat="server"></asp:label>页</TD>
         <TD noWrap width="5%">
          <asp:Button ID="btnFirst" runat="server" Text="首页" CausesValidation="False" OnClick="btnFirst_Click" /></TD>
         <TD noWrap width="5%">
          <asp:Button ID="btnPreview" runat="server" Text="上页" CausesValidation="False" OnClick="btnPreview_Click" /></TD>
         <TD noWrap width="5%">
          <asp:Button ID="btnNext" runat="server" Text="下页" CausesValidation="False" OnClick="btnNext_Click" /></TD>
         <TD noWrap width="5%">
          <asp:Button ID="btnLast" runat="server" Text="末页" CausesValidation="False" OnClick="btnLast_Click" /></TD>
         <TD noWrap width="20%"><FONT face="宋体"> </FONT>
         </TD>
         <TD noWrap width="20%">转到
          <asp:dropdownlist id="ddlJumpToPageNum" runat="server" AutoPostBack="True" onselectedindexchanged="ddlJumpToPageNum_SelectedIndexChanged"></asp:dropdownlist>页</TD>
        </TR>
       
       </TABLE>

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

后台：===========================================================

public partial class downpage : System.Web.UI.Page
{
    protected int pageNum = 1;
    protected int recNum = 0;
    protected int pageRecNum = 20;/这里是每页的记录数，可以改动
    protected int curPageNO = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindRepeater1();
            BindRepeater2();
            SqlConnection myConn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            string strSQL = "select count(*) from downfile";
            SqlCommand mycommand = new SqlCommand(strSQL, myConn);
            myConn.Open();
            recNum = Convert.ToInt32(mycommand.ExecuteScalar());
            lblRecNum.Text = mycommand.ExecuteScalar().ToString();
            myConn.Close();
            //-----------pageRecNum 
            //------------------pageRecNum,pageNum 
            if (recNum > 0)
            {
                if (recNum % pageRecNum == 0)
                {
                    pageNum = recNum / pageRecNum;
                }
                else
                {
                    pageNum = Convert.ToInt32(recNum / pageRecNum) + 1;
                    if (pageNum == 1)
                    {
                        btnFirst.Enabled = false;
                        btnPreview.Enabled = false;
                        btnNext.Enabled = false;
                        btnLast.Enabled = false;
                    }
                }
            }
            else
            {
                pageNum = 1;
                btnFirst.Enabled = false;
                btnPreview.Enabled = false;
                btnNext.Enabled = false;
                btnLast.Enabled = false;
            }
            for (int i = 1; i <= pageNum; i++)
            {
                ddlJumpToPageNum.Items.Add(i.ToString());
            }
            lblPageNum.Text = pageNum.ToString();
            ViewState["PageRowNum"] = pageRecNum;
            ViewState["RecNum"] = recNum;
            ViewState["PageNum"] = pageNum;
            //-----------------curPageNO 
            curPageNO = 1;
            ViewState["CurPageNO"] = curPageNO;
            //------------------ 
        }
        pageRecNum = Convert.ToInt32(ViewState["PageRowNum"]);
        recNum = Convert.ToInt32(ViewState["RecNum"]);
        curPageNO = Convert.ToInt32(ViewState["CurPageNO"]);
        pageNum = Convert.ToInt32(ViewState["PageNum"]);
        //------------pageNum 
        if (pageRecNum == -1 || recNum == -1)
        {
            Response.Write("发生错误!");
            Response.End();
        }
        if (curPageNO <= 1)
        {
            curPageNO = 1;
            btnFirst.Enabled = false;
            btnPreview.Enabled = false;
        }
        //----------------- 
        //lblRecNum.Text = recNum.ToString(); 
        lblCurPageNO.Text = ViewState["CurPageNO"].ToString();
        //----------------- 
        if (!Page.IsPostBack)
        {
            BindData();
        }
    } 
    #region datelist 
    private void BindData()
    {
        string commandText = "select * from downfile order by id desc";
        //---------- 
        SqlConnection myConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
        SqlCommand cmd = new SqlCommand(commandText, myConn);
        cmd.Parameters.Add("@tj", true);
        myConn.Open();
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        da.Fill(ds, (Convert.ToInt32(ViewState["CurPageNO"]) - 1) * pageRecNum, pageRecNum, "editor");
        //---------- 
        Repeater.DataSource = ds.Tables["editor"]; /如果是DataList就换成DataListID
        Repeater.DataBind();/如果是DataList就换成DataListID
        ds.Clear();
        myConn.Close();
        lblCurPageNO.Text = ViewState["CurPageNO"].ToString();
    } 
    #endregion 
    #region 移动页面 
    private void MoveFirst()
    {
        curPageNO = 1;
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------ 
        btnFirst.Enabled = false;
        btnPreview.Enabled = false;
        btnNext.Enabled = true;
        btnLast.Enabled = true;
    }
    private void MovePrevious()
    {
        curPageNO = Convert.ToInt32(ViewState["CurPageNO"]) - 1;
        if (curPageNO == 0)
        {
            curPageNO = 1;
        }
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------ 
        if (curPageNO == 1)
        {
            btnFirst.Enabled = false;
            btnPreview.Enabled = false;
        }
        btnNext.Enabled = true;
        btnLast.Enabled = true;
    }
    private void MoveNext()
    {
        curPageNO = Convert.ToInt32(ViewState["CurPageNO"]) + 1;
        if (curPageNO <= pageNum)
        {
            ViewState["CurPageNO"] = curPageNO;
        }
        else
        {
            ViewState["CurPageNO"] = pageNum;
        }
        BindData();
        //------ 
        btnFirst.Enabled = true;
        btnPreview.Enabled = true;
        if (curPageNO >= pageNum)
        {
            curPageNO = pageNum;
            btnNext.Enabled = false;
            btnLast.Enabled = false;
        }
    }
    private void MoveLast()
    {
        curPageNO = pageNum;
        ViewState["CurPageNO"] = curPageNO.ToString();
        BindData();
        //------ 
        btnFirst.Enabled = true;
        btnPreview.Enabled = true;
        btnNext.Enabled = false;
        btnLast.Enabled = false;
    } 
    #endregion 
    protected void btnFirst_Click(object sender, System.EventArgs e)
    {
        MoveFirst();
        binddrop();
    }
    protected void btnPreview_Click(object sender, System.EventArgs e)
    {
        MovePrevious();
        binddrop();
    }
    protected void btnNext_Click(object sender, System.EventArgs e)
    {
        MoveNext();
        binddrop();
    }
    protected void btnLast_Click(object sender, System.EventArgs e)
    {
        MoveLast();
        binddrop();
    }
    private void binddrop()
    {
        this.ddlJumpToPageNum.SelectedValue = curPageNO.ToString();
    }
    protected void ddlJumpToPageNum_SelectedIndexChanged(object sender, System.EventArgs e)
    {
        ViewState["CurPageNO"] = Convert.ToInt32(ddlJumpToPageNum.SelectedValue);
        if (Convert.ToInt32(ddlJumpToPageNum.SelectedValue) == 1)
        {
            btnFirst.Enabled = false;
            btnPreview.Enabled = false;
            btnNext.Enabled = true;
            btnLast.Enabled = true;
        }
        else
        {
            if (Convert.ToInt32(ddlJumpToPageNum.SelectedValue) == pageNum)
            {
                btnFirst.Enabled = true;
                btnPreview.Enabled = true;
                btnNext.Enabled = false;
                btnLast.Enabled = false;
            }
            else
            {
                btnFirst.Enabled = true;
                btnPreview.Enabled = true;
                btnNext.Enabled = true;
                btnLast.Enabled = true;
            }
        }
        BindData();
    }
}