Default.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Repeater1.DataSource = DbHelperSQL.Query("select * from productType ");
            Repeater1.DataBind();

           
        }
    }
    protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
        {
            string tid = DataBinder.Eval(e.Item.DataItem, "tid").ToString();
            Repeater rp = (Repeater)e.Item.FindControl("Repeater2");

            rp.DataSource = DbHelperSQL.Query("select top 4 * from products where tid=" + tid + " and Flag='上架' order by pid desc");
            rp.DataBind();  
        }
    }
}