<asp:Repeater ID="rpt1" runat="server" >
<ItemTemplate>
<table width="777" border="0" cellpadding="0" cellspacing="1" bgcolor="#009900" class="tb">
<!--DWLayoutTable-->
<tr>
<td align="center" valign="middle" bgcolor="#FFFFFF" style="height: 25px">姓名:<%#DataBinder . Eval(Container .DataItem ,"username")%></td>
</tr>
<tr>
<td height="20" colspan="2" align="left" valign="top" bgcolor="#FFFFFF">ID:<%#DataBinder . Eval(Container .DataItem ,"id")%> </td>
<asp:LinkButton ID="LinkButton2" runat="server" OnClick="LinkButton2_Click" >删除</asp:LinkButton>
<td align="left" valign="middle" bgcolor="#FFFFFF" style="height: 10px"> 时间:<%# DataBinder .Eval (Container .DataItem ,"createtime") %></td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
protected void Page_Load(object sender, EventArgs e)
{
showInformation();
}
private string myconnectionstring = "server=127.0.0.1;uid=sa;pwd=;database=BBS;";
protected void showInformation()
{
SqlConnection myconnection = new SqlConnection(myconnectionstring);
string sql = "select * from content order by id desc";
SqlCommand mycommand = new SqlCommand(sql, myconnection);
myconnection.Open();
SqlDataReader myreader = mycommand.ExecuteReader();
rpt1.DataSource = myreader;
rpt1.DataBind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
}