自定义DataList分页

 

前台主要代码：
<table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td>
                              <asp:DataList ID="DataList1" runat="server" Width="65%" OnItemDataBound="DataList1_ItemDataBound">
                                  <ItemTemplate>
                                      <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                          <tr>
                                              <td style="width:10px;"></td>
                                              <td height="31">
                                                  <asp:LinkButton ID="LkbTitle" runat="server" CommandArgument='<%# Eval("ArticleID") %>'
                                                      Text='<%# Eval("Title") %>' Font-Size="Medium" ForeColor="Blue" OnClick="LkbTitle_Click"></asp:LinkButton>
                                              </td>
                                          </tr>
                                          <tr>
                                          <td style="width:10px;"></td>
                                              <td>
                                                  <span>
                                                      <asp:Label ID="labCount" runat="server" Text='<%# Eval("Content") %>'></asp:Label>
                                                  </span></td>
                                          </tr>
                                          <tr>
                                          <td style="width:10px;"></td>
                                              <td align="right" height="31">
                                                  <span class="STYLE19">发布时间 - <asp:Label ID="labDate" runat="server" Text='<%# Eval("UpdateTime") %>'></asp:Label> -</span></td>
                                          </tr>
                                      </table>
                                  </ItemTemplate>
                              </asp:DataList>
                          </td>
                        </tr>
                      </table>
                      <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td height="20" align="center">
                            <div id="PageInfo" runat="server"></div>
                          </td>
                        </tr>
                      </table>

后台主要代码：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Fps_NewsResult : System.Web.UI.Page
{
    //总记录数目
    int TotalCountRecord;
    //每页显示的条数
    int PageItem = 10;
    //当前页数
    int CurrentPage = 1;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["page"] != null)
            {
                CurrentPage = Convert.ToInt32(Request.QueryString["page"]);
            }
            BuildGrid();
        }
    }

    public void BuildGrid()
    {
         tring sqlstr = "SELECT ArticleID, Title, Content,UpdateTime FROM Article  ORDER BY UpdateTime      DESC";
        SqlConnection mycoon = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter(sqlstr, mycoon);
        DataSet ds = new DataSet();
        int startRecord = (CurrentPage - 1) * PageItem;
        da.Fill(ds, startRecord, PageItem, "Article");
        DataList1.DataSource = ds.Tables["Article"].DefaultView;
        DataList1.DataBind();
        SqlCommand mycmd = new SqlCommand();
        mycmd.CommandText = "SELECT COUNT(*) FROM Article";
        mycmd.Connection = mycoon;
        mycoon.Open();
        //得到总记录条数
        TotalCountRecord = (int)mycmd.ExecuteScalar();
        mycoon.Close();
        BuildPagers();
    }

    public void BuildPagers()
    {
        //偏移量
        int Step = 10;
        int LeftNum = 0;
        int RightNum = 0;
        string PageUrl = "*.aspx";//*设置为当前页面
        int PageCount = (int)Math.Ceiling((double)(TotalCountRecord) / PageItem);
        if (CurrentPage - Step < 1)
        {
            LeftNum = 1;
        }
        else
        {
            LeftNum = CurrentPage - Step;
        }

        if (CurrentPage + Step > PageCount)
        {
            RightNum = PageCount;
        }
        else
        {
            RightNum = CurrentPage + Step;
        }
        string OutPut = "";
        for (int i = LeftNum; i <= RightNum; i++)
        {
            if (i == CurrentPage)
            {
                OutPut += "<font color=red>" + i.ToString() + "</font>";
            }
            else
            {
                OutPut += "<a href='" + PageUrl + "?key=" + Key + "&page=" + i.ToString() + "'>[" + i.ToString() + "]</a>";
            }
        }
        if (CurrentPage > 1)
        {
            OutPut = "<a href='" + PageUrl + "?key=" + Key + "&page=" + (CurrentPage - 1) + "'>上一页</a>" + OutPut;
        }

        if (CurrentPage < PageCount)
        {
            OutPut += "<a href='" + PageUrl + "?key=" + Key + "&page=" + (CurrentPage + 1) + "'>下一页</a>";
        }

        PageInfo.InnerHtml = OutPut;
    }
}