62,243
社区成员




<div id="msglist">
<asp:Repeater ID="Rep" OnItemDataBound="RowItemDataBound" runat="server">
<ItemTemplate>
<table class="tablestyle">
<tr>
<td class="lf">
<ul>
<li><a href="#"><img src='<%#Eval("UserImage") %>' alt="0"/></a></li>
<li><em><%#Eval("UserName") %></em></li>
<li>(<%#Eval("UserName") %>)</li>
<li>等级:★★★★★</li>
<li>结贴率:100%</li>
</ul>
</td>
<td class="rw">
<div class="fbart">发表于:<%#Eval("UserTime", "{0:yyyy-M-dd HH:mm:ss}")%><em>11</em></div>
<div class="msgfont"><%#Eval("UserMessage") %></div>
<div class="fdart"><span class='<%#Eval("ID") %>'><a href="#" class="btndelete">删除</a></span></div>
</td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
</div>
<div id="page">
<asp:LinkButton ID="lnkbtnFrist" runat="server" OnClick="lnkbtnFrist_Click">首页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnPre" runat="server" OnClick="lnkbtnPre_Click">上一页</asp:LinkButton>
<asp:Label ID="labtotal" runat="server"></asp:Label>
<asp:LinkButton ID="lnkbtnNext" runat="server" OnClick="lnkbtnNext_Click">下一页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnLast" runat="server" OnClick="lnkbtnLast_Click">尾页</asp:LinkButton>
跳转到第<asp:DropDownList ID="CurrentPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> </asp:DropDownList>页</div>
</div>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MessageList();
}
}
PagedDataSource pg = new PagedDataSource();//创建分页控件对象
public void MessageList()
{
string sql = "select * from T_BBS order by usertime desc";
DataTable dt = SqlHelper.ExcuteSqlReturnTable(sql);
Rep.DataSource = dt;
Rep.DataBind();
CurrentPage.Items.Clear();
pg.DataSource = dt.DefaultView;
pg.AllowPaging = true;//启用分页
pg.PageSize = 2;//页面条数
for (int i = 1; i <= pg.PageCount; i++)
{
CurrentPage.Items.Add(i.ToString());
}
CurrentPage.SelectedIndex = pg.CurrentPageIndex;
}
protected void RowItemDataBound(object sender, RepeaterItemEventArgs e)
{
labtotal.Text = string.Format("当前第{0}页/总共{1}页", pg.CurrentPageIndex + 1, pg.PageCount);
}
//下拉列表
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
this.pg.CurrentPageIndex = this.CurrentPage.SelectedIndex;
MessageList();
}
// 首页
protected void lnkbtnFrist_Click(object sender, EventArgs e)
{
this.pg.CurrentPageIndex = 0;
MessageList();
}
//上页
protected void lnkbtnPre_Click(object sender, EventArgs e)
{
if (this.pg.CurrentPageIndex > 0)
{
this.pg.CurrentPageIndex = this.pg.CurrentPageIndex - 1;
MessageList();
}
}
//下页
protected void lnkbtnNext_Click(object sender, EventArgs e)
{
if (this.pg.CurrentPageIndex < this.pg.PageCount)
{
this.pg.CurrentPageIndex = this.pg.CurrentPageIndex - 1;
MessageList();
}
}
//尾页
protected void lnkbtnLast_Click(object sender, EventArgs e)
{
this.pg.CurrentPageIndex = this.pg.PageCount;
MessageList();
}
List<myWeb.Model.tbl_Nav> listCompany = bll_Nav.GetModelList("");
AspNetPager1.RecordCount = listCompany.Count;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.DataSource = listCompany;
Repeater1.DataSource = pds;
Repeater1.DataBind();