如表;
表A:
ID A1 A2 A3 ......
表B :
ID A1 A2 B3 .......
现想用NET里的Relations 把两表关联起来,即A.A1与B.A2 A.A2与B.A2 关联 请高手帮忙指导
表A:
ID A1 A2 A3 ......
表B :
ID A1 A2 B3 .......
现想用NET里的Relations 把两表关联起来,即A.A1与B.A2 A.A2与B.A2 关联 请高手帮忙指导
myDataset.Table["A"]
myDataset.Table["B"]
然后通过 DataRelation 把A.A1与B.A2 A.A2与B.A2 关联
DataColumn childCol;
parentCol = myDataset.Table["A"].Columns["A1"];
childCol = myDataset.Table["B"].Columns["A2"]; DataRelation relCustOrder;
relCustOrder = new DataRelation("CustomersOrders", parentCol, childCol);
// Add the relation to the DataSet.
DataSet1.Relations.Add(relCustOrder);
myDataset.Table["A"]
myDataset.Table["B"]
然后通过 DataRelation 把A.A1与B.A1 A.A2与B.A2 关联
谢谢j_lei407(落日一笑) 解答