datalist 嵌套

using System;

using System.Data;

 using System.Configuration;

 using System.Collections;

using System.Web;

using System.Web.Security;

 using System.Web.UI;

 using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

 

public partial class DataListNesting : System.Web.UI.Page

 {

 private void BindList()

{

SqlConnection cn = new SqlConnection(@"server=./sqlexpress;uid=sa;pwd=;database=northwind");

SqlDataAdapter da = new SqlDataAdapter("select OrderID, CustomerID from Orders", cn);

DataSet ds = new DataSet();

 cn.Open();

 da.Fill(ds);

 cn.Close();

DataList1.DataSource = ds.Tables[0].DefaultView;

DataList1.DataKeyField = "orderID"; DataList1.DataBind();

}

 

private void Page_Load(object sender, System.EventArgs e)

 {

 

 if (!IsPostBack)

{

BindList();

}

}

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)

{

DataList datalist2;

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

datalist2 = e.Item.FindControl("DataList2") as DataList;

 

if (datalist2 != null)

{

SqlConnection cn = new SqlConnection(@"server=./sqlexpress;uid=sa;pwd=;database=northwind;");

SqlDataAdapter da = new SqlDataAdapter("select ProductID, UnitPrice, Quantity from [Order Details] where orderID = @orderID", cn); da.SelectCommand.Parameters.AddWithValue("@orderID", (e.Item.DataItem as DataRowView)["orderID"]);

DataSet ds = new DataSet(); cn.Open(); da.Fill(ds); cn.Close(); datalist2.DataSource = ds.Tables[0].DefaultView;

datalist2.DataBind();

 }

}

}

}