Datalist 嵌套DataList

阿呆0123

于 2010-09-13 20:30:00 发布

阅读量516

点赞数

分类专栏： Asp.net 文章标签： dataset server exception table border string

本文链接：https://blog.csdn.net/pengfeihe0123/article/details/5881760

版权

Asp.net 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

datalist 嵌套 datalist 就相当于双循环，里面的那个datalist 显示的内容跟外面的那个datalist 的值有关联，下面是个小练习，代码如下

=======页面代码

======后台代码
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=sasa");
            DataSet ds = new DataSet();
            string sql = "select * from zhuInfo ";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            da.Fill(ds, "zhuInfo");
            this.DataList1.DataSource = ds.Tables[0];
            this.DataList1.DataBind();

        }
    }
    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            DataList dataList = (DataList)e.Item.FindControl("dlsProductInfo");
            DataRowView rowv = (DataRowView)e.Item.DataItem;
            string name = rowv["Name"].ToString();

            if (name.Length > 0)
            {
                DataSet ds = select(name); //获取从数据。
                if (ds != null)
                {
                    try
                    {
                        dataList.DataSource = ds.Tables[0];
                        dataList.DataBind();
                    }
                    catch (Exception ex)
                    {
                        throw new Exception(ex.Message);
                    }
                }
            }
        }

}

    public DataSet select(string name)
    {
        SqlConnection conn = new SqlConnection("server=.;database=test;uid=sa;pwd=sasa");
        DataSet ds = new DataSet();
        string sql = "select * from congInfo where zName='" + name + "'";
        SqlDataAdapter da=new SqlDataAdapter(sql,conn);
        da.Fill(ds,"congInfo");
        return ds;

}