[ASP.NET2.0]Repeater C# 循环显示数据

[ASP.NET2.0]Repeater C# 循环显示数据
一、脚本

 protected void Page_Load(object sender, EventArgs e)
 　　{
 　　　　if (!IsPostBack)
 　　{
 　　　　DataSet set = new DataSet();
 　　　　string qrynews = "select top 5 * from product order by phit desc";
 　　　　string conn2 = System.Configuration.ConfigurationManager.AppSettings["haikelasiConnectionString"].ToString();
 　　　　SqlDataAdapter sda2 = new SqlDataAdapter(qrynews, conn2);
 　　　　sda2.Fill(set);

　　　　toplist.DataSource = set.Tables[0].DefaultView;
　　　　toplist.DataBind();
　　}
 

 

二、页面显示

 <asp:Repeater ID="toplist" runat="server">
   <ItemTemplate>
        <div id="topprotitle">
            <img src="images/jt.gif" /><a href=product.aspx class="linkwhite"> <%#DataBinder.Eval(Container.DataItem, "Pcontent")%></a>
         </div>
         <div>
             <a href="product.aspx?id=<%#DataBinder.Eval(Container.DataItem, "pid")%>"><img src="images/products/<%#DataBinder.Eval(Container.DataItem, "Pname")%>" class="productimg2" height="120" /></a>
         </div>
         <div id="prohengtiao">
            <table border=0 cellpadding=0 cellspacing=0>
                <tr>
                    <td height=1></td>
                </tr>
            </table>
        </div>
    </ItemTemplate>
</asp:Repeater>