復制代碼 代碼如下:

<asp:Repeater runat="server">
<HeaderTemplate><!--頭-->
<ul>
</HeaderTemplate>
<ItemTemplate><!--中間循環部分-->
<li> • <a href="AritcleDisplay.aspx?id=<%#Eval("id") %>" target="_blank"><%#Eval("title").ToString().Length>30?Eval("title").ToString().Substring(0,30)+"...":Eval("title")%></a></li>
</ItemTemplate>
<FooterTemplate><!--尾-->
</ul>
</FooterTemplate>
</asp:Repeater>

復制代碼 代碼如下:

string indexTopMainStr = "select top 9 id,title from Table order by ID desc";
SqlDataAdapter rst = new SqlDataAdapter(indexTopMainStr,conn);
conn.Open();
DataSet rdt = new DataSet();
rst.Fill(rdt);
IndexTopMain.DataSource = rdt;//數據綁定
IndexTopMain.DataBind();
conn.Close();