Dim tbRightHtml As StringBuilder = New StringBuilder() tbRightHtml.AppendLine("<table id='tbRight' cellpadding='0' cellspacing='0' width='" & (dtBind.Columns.Count - 3) * 100 & "px'>") For i_row As Integer = 0 To dtBind.Rows.Count - 1 If i_row Mod 2 = 0 Then tbRightHtml.AppendLine("<tr height='40px'>") Else tbRightHtml.AppendLine("<tr height='40px' style='background-color:lavender;'>") End If Next
$("tr:even").css();
Dim tbRightHtml As StringBuilder = New StringBuilder()
tbRightHtml.AppendLine("<table id='tbRight' cellpadding='0' cellspacing='0' width='" & (dtBind.Columns.Count - 3) * 100 & "px'>") For i_row As Integer = 0 To dtBind.Rows.Count - 1 If i_row Mod 2 = 0 Then tbRightHtml.AppendLine("<tr height='40px'>")
Else
tbRightHtml.AppendLine("<tr height='40px' style='background-color:lavender;'>")
End If
Next
++1,JQuery方便,又不知道LZ用什么控件显示的留言
StringBuilder tbRightHtml = new StringBuilder();
tbRightHtml.AppendLine("<table id='tbRight' cellpadding='0' cellspacing='0' width='" + (dtBind.Columns.Count - 3) * 100 + "px'>");
for (int i_row = 0; i_row <= dtBind.Rows.Count - 1; i_row++) { if (i_row % 2 == 0) {
tbRightHtml.AppendLine("<tr height='40px'>");
} else {
tbRightHtml.AppendLine("<tr height='40px' style='background-color:lavender;'>");
}
}
<html>
<head>
<title>在线留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body leftmargin="0" topmargin="0" background="img/01.jpg">
<uc1:top id="top1" runat="server"></uc1:top>
<table width="980" height="20" border="0" align="center" cellpadding="0" cellspacing="0"
bgcolor="#ffffff">
<tr>
<td> </td>
</tr>
</table>
<table width="980" height="30" border="0" align="center" cellpadding="0" cellspacing="0"
bgcolor="#ffffff">
<tr>
<td width="20%" align="center"><a href="add.aspx"><img src="img/05.jpg" width="120" height="28" border="0" alt="0" /></a></td>
<td width="20%"><a href="admin.aspx"><img src="img/06.jpg" width="120" height="28" border="0" alt="0" /></a></td>
<td width="45%"> </td>
<td width="10%"><a href="#" target="_blank" class="css">[返回首页]</a></td>
</tr>
</table>
<table width="980" height="20" border="0" align="center" cellpadding="0" cellspacing="0"
bgcolor="#ffffff">
<tr>
<td> </td>
</tr>
</table>
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#ffffff">
<tr>
<td>
<asp:Repeater id="RepeaterPage" runat="server">
<ItemTemplate>
<table width="930" border="0" align="center" bordercolorlight="#99cc99" bordercolordark="#669933" bgcolor="#dde3ce">
<tr>
<td width="109" rowspan="4" align="center" bgcolor="#ffffff" class="css"><img src="img/07.jpg" width="69" height="68"><br />
<font color="#ff0000"><%# DataBinder.Eval(Container.DataItem,"username")%></font></td>
<td bgcolor="#ffffff" class="css">发表时间:<%# DataBinder.Eval(Container.DataItem,"addtime")%></td>
<td bgcolor="#ffffff" class="css" width="247">主题:<strong><font color="#cc6600"><%# DataBinder.Eval(Container.DataItem,"title")%></font></strong></td>
<td bgcolor="#ffffff" class="css"><table width="60%" height="19" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td><img src="img/friend.gif" alt="来自" width="18" height="18" alt="0" /></td>
<td><img src="img/qq.gif" alt="qq号:<%# DataBinder.Eval(Container.DataItem,"qq")%>" width="18" height="18"></td>
<td><img src="img/MAIL.gif" alt="Email:<%# DataBinder.Eval(Container.DataItem,"email")%>" width="18" height="18"></td>
<td><img src="img/ip.gif" alt="IP:<%# DataBinder.Eval(Container.DataItem,"ip")%>" width="18" height="18" border="0"></td>
<td><img src="img/url.gif" alt="主页" width="18" height="18"></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="3" bgcolor="#ffffff" class="never"><%# DataBinder.Eval(Container.DataItem,"content")%></td>
</tr>
<tr>
<td colspan="3" bgcolor="#ffffff" class="css"><font color="#666666">-----------------------------------------------------------------------------------------------------------
</font><font color="#666666"> </font><a href="replay.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id")%>">[回复]</a> <a href="del.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id")%>">[删除]</a><br></td>
</tr>
<tr>
<td colspan="3" bgcolor="#ffffff" class="css"><font color="#999999">管理员回复:<%# DataBinder.Eval(Container.DataItem,"huifu")%></font></td>
</tr>
</table>
<table width="75%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
<table width="75%" border="0" align="center" class="css">
<tr>
<td align="center"><asp:HyperLink id="lnkPrev" runat="server">上一页</asp:HyperLink> <asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink> <asp:label id="lblCurPage" runat="server"></asp:label></td>
</tr>
</table>
</td>
</tr>
</table>
<uc2:buttom id="buttom1" runat="server"></uc2:buttom>
</body>
</HTML>
public class index : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Repeater RepeaterPage;
protected System.Web.UI.WebControls.HyperLink lnkPrev;
protected System.Web.UI.WebControls.HyperLink lnkNext;
protected System.Web.UI.WebControls.Label lblCurPage;
config obj = new config();
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
RepeaterDataBind();
}
} private void RepeaterDataBind()
{
//定义数据连接对象,其中数据库连接字符串是在Web.Config文件中定义的
obj.open(); //创建数据适配器对象
OleDbDataAdapter da = new OleDbDataAdapter("select * from guestbook order by addtime desc",obj.myconn);
//创建DataSet对象
DataSet ds = new DataSet();
try
{
//填充数据集
da.Fill(ds,"guestbook");
//创建分页类
PagedDataSource objPage = new PagedDataSource();
//设置数据源
objPage.DataSource = ds.Tables["guestbook"].DefaultView;
//允许分页
objPage.AllowPaging = true;
//设置每页显示的项数
objPage.PageSize = 10;
//定义变量用来保存当前页索引
int CurPage;
//判断是否具有页面跳转的请求
if (Request.QueryString["Page"] != null)
CurPage=Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage=1;
//设置当前页的索引
objPage.CurrentPageIndex = CurPage-1;
//显示状态信息
lblCurPage.Text = "当前页:第" + CurPage.ToString()+"页";
//如果当前页面不是首页
if (!objPage.IsFirstPage)
//定义"上一页"超级链接的URL为:当前执行页面的虚拟路径,并传递下一页面的索引值
lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);
//如果当前页面不是最后一页
if (!objPage.IsLastPage)
//定义"下一页"超级链接的URL为:当前执行页面的虚拟路径,并传递下一页面的索引值
lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1); //进行数据绑定
RepeaterPage.DataSource = objPage;
RepeaterPage.DataBind();
}
catch(Exception error)
{
Response.Write(error.ToString());
}
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
<asp:Repeater id="RepeaterPage" runat="server">
<ItemTemplate>
//....
<tr style='background-color: <%#(Container.ItemIndex%2==0)? "#fbfbfb" : "#f0f0f0" %>'>
//类似于这种形式就可以