1..先建立两下表的关系
DataColumn dcMaster = this.dt.Tables[0].Columns["EmployeeID"];
DataColumn dcDetail = this.dt.Tables[1].Columns["EmployeeID"];
DataRelation dr = new System.Data.DataRelation("myRela",dcMaster,dcDetail,true);
dt.Relations.Add(dr);
2..用GetChildRows 方法就可得到
DataRow[] drarray;
// GetChildRows gets related rows. It is a method on the datatable, and
// takes either DataRelation object name as a string.
rowCtr = 0;
drarray = dsCustomersOrders1.Customers[rowCtr].GetChildRows("CustomersOrders");
3..再绑定既可
DataColumn dcMaster = this.dt.Tables[0].Columns["EmployeeID"];
DataColumn dcDetail = this.dt.Tables[1].Columns["EmployeeID"];
DataRelation dr = new System.Data.DataRelation("myRela",dcMaster,dcDetail,true);
dt.Relations.Add(dr);
2..用GetChildRows 方法就可得到
DataRow[] drarray;
// GetChildRows gets related rows. It is a method on the datatable, and
// takes either DataRelation object name as a string.
rowCtr = 0;
drarray = dsCustomersOrders1.Customers[rowCtr].GetChildRows("CustomersOrders");
3..再绑定既可
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货