Datalist与DataGrid的嵌套

DataKeyField="ID" BorderStyle="Solid" BorderWidth="0px" CellPadding="1" CellSpacing="2" ShowHeader="False"
ShowFooter="False">


ID号:<%# DataBinder.Eval(Container.DataItem,"ID") %>
EDN号:<%# DataBinder.Eval(Container.DataItem,"EDN") %>
计划发运日期:<%# DataBinder.Eval(Container.DataItem,"planTime") %>
行号:<%# DataBinder.Eval(Container.DataItem, "TI") %>
金额:<%# DataBinder.Eval(Container.DataItem, "price") %>
工程号:<%# DataBinder.Eval(Container.DataItem, "projectNumber") %>

---

BorderStyle="Solid" HorizontalAlign="Center" BorderWidth="0px" CellPadding="2" AllowPaging="True"
AutoGenerateColumns="False" CellSpacing="1" ForeColor="Black" PageSize="15">


BackColor="White">
BorderColor="IndianRed" BackColor="#FFECCA">





ForeColor="Red" Position="TopAndBottom" BackColor="Lavender" Mode="NumericPages">




@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
.CS的代码；
＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠＠
private void DList_Class_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==ListItemType.AlternatingItem)
{
DataGrid dg=(DataGrid)e.Item .FindControl("DG_SubClass");
string itemIndex =this.DList_Class.DataKeys[e.Item .ItemIndex].ToString();

//string[] strSQLArray =new string[1]{"select Top 10 materialNumber,number,materialDescriber from T_MaterialerWorkDetail where ID in ( "+itemIndex+");"};
//string strSql=string.Concat(strSQLArray);
SqlConnection sqlcon=db.GetConnection ();
sqlcon.Open ();
//string sql="select materialNumber,number,materialDescriber from T_MaterialerWorkDetail where TI='35534' and projectNumber='50012345'";
//string TableName ="SubClass"+itemIndex;

string sql="SELECT dbo.T_MaterialerW

orkDetail.materialNumber, dbo.T_MaterialerWorkDetail.number,";
sql+="dbo.T_MaterialerWorkDetail.materialDescriber,dbo.T_MaterialerWork.id AS Expr1";
sql+=" FROM dbo.T_MaterialerWork INNER JOIN dbo.T_MaterialerWorkDetail ON ";
sql+="dbo.T_MaterialerWork.TI = dbo.T_MaterialerWorkDetail.TI AND ";
sql+="dbo.T_MaterialerWork.projectNumber = dbo.T_MaterialerWorkDetail.projectNumber AND dbo.T_MaterialerWork.id="+Convert .ToInt32(itemIndex);

DataSet ds=new DataSet ();
SqlDataAdapter sqlda=new SqlDataAdapter (sql,sqlcon);
sqlda.Fill(ds,"TableName");


//AdapterFill(ds, CommandType.Text, strSql, TableName, new SqlParameter[0]);

//dg.ItemDataBound += new System.Web.UI.WebControls .DataGridItemEventHandler(this.DG_SubClass_ITemDataBound);

dg.DataSource =ds.Tables["TableName"].DefaultView;
dg.DataBind();
}

}