在DataSet中建立两个 DataTable 对象之间的父/子关系

来源：互联网发布：金融数据分析平台编辑：程序博客网时间：2024/05/16 14:39

1。建立两个 DataTable 对象之间的父/子关系
>>>>DataColumn parentCol;
    DataColumn childCol;
    parentCol = DataSet1.Tables["Customers"].Columns["CustID"];
    childCol = DataSet1.Tables["Orders"].Columns["CustID"];
    DataRelation relCustOrder;
    relCustOrder = new DataRelation("CustomersOrders", parentCol, childCol);
    DataSet1.Relations.Add(relCustOrder);
2。获得相关数据
private void GetChildRowsFromDataRelation(DataTable myTable ) {
    DataRow[] arrRows;
    foreach(DataRelation myRelation in myTable.ChildRelations){
       foreach(DataRow myRow in myTable.Rows){
          arrRows = myRow.GetChildRows(myRelation, DataRowVersion.Proposed);
          // Print values of rows.
          for(int i = 0; i < arrRows.Length; i++){
             foreach(DataColumn myColumn in myTable.Columns){
                Console.WriteLine(arrRows[i][myColumn]);
             }
          }
       }
    }
}