菜鸟问题:一个DataGrid如何绑定多表??

gamethelife 2005-05-14 04:18:33

例如有两个相关联的表需要在同一个DataGrid上显示, 单击+号展开子表!

...全文

133 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

gamethelife 2005-05-14

打赏
举报

to : drk928
感谢!

to : _jfeng
只在同一个DataGrid内!

_jfeng 2005-05-14

打赏
举报

// C#
DataRelation myDataRelation;
myDataRelation = new DataRelation("CustOrd", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]);
// Add the relation to the DataSet.
ds.Relations.Add(myDataRelation);
GridOrders.SetDataBinding(ds,"Customers");
GridDetails.SetDataBinding(ds,"Customers.CustOrd");

SeeSunSet 2005-05-14

打赏
举报

Fill(Ds,"Customers");
Fill(Ds,"Orders");
DataColumn parentCol;
DataColumn childCol;
// Code to get the DataSet not shown here.
parentCol = Ds.Tables["Customers"].Columns["CustID"];
childCol = Ds.Tables["Orders"].Columns["CustID"];
// Create DataRelation.
DataRelation relCustOrder;
relCustOrder = new DataRelation("CustomersOrders", parentCol, childCol);
// Add the relation to the DataSet.
Ds.Relations.Add(relCustOrder);
DataGrid1.DataSource=Ds;
DataGrid1.DataBind();

gamethelife 2005-05-14