<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;
}
}