111,125
社区成员
发帖
与我相关
我的任务
分享 <table border="0" cellpadding="0" cellspacing="1" class="list">
<tr>
<td width="30px" align="center">
<input type="checkbox" id="CheckAll" onclick='javascript:SelAll(this.form)' title='全选/全消' /></td>
<td width="10%" align="center">
栏目</td>
<td align="center">
标题</td>
<td width="15%" align="center">
日期</td>
<td width="10%" align="center">
作者</td>
<td width="8%" align="center">
浏览</td>
<td width="8%" align="center">
回复</td>
<td width="30px" align="center">
编辑</td>
</tr>
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<tr>
<td align="center">
<asp:Label ID="ID" runat="server" Visible="false" Text='<%#Eval("ID")%>'>
</asp:Label><asp:CheckBox ID="CHK" runat="server"></asp:CheckBox>
</td>
<td align="center">
<%#Eval("Name")%>
</td>
<td>
<%# Eval("Title")%>
</td>
<td align="center">
<%#Eval("Dtime")%>
</td>
<td align="center">
<%#Eval("Writer")%>
</td>
<td align="center">
<%#Eval("Hit")%>
</td>
<td align="center">
<%#Eval("Reopen").ToString() == "1" ? "允许" : "不允许"%>
</td>
<td align="center">
<a href="ContentEdit.aspx?ID=<%# Eval("ID")%>">
<img src="images/edit.gif" border="0" /></a>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table> void BindData(string tmpKeywords)
{
if (tmpKeywords == null || tmpKeywords == "")
tmpKeywords = "%";
string tmpSql = "SELECT Category.Name, Content.* FROM Content INNER JOIN Category ON Content.CID = Category.ID where (Title like '%" + tmpKeywords + "%' or Content like '%" + tmpKeywords + "%')";
AspNetPager1.RecordCount = BDB.GetTab(tmpSql, 0, 0).Rows.Count;
DataTable dt = BDB.GetTab(tmpSql + " order by Content.ID desc", AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
Repeater1.DataSource = dt.DefaultView;
Repeater1.DataBind();
}