Comments by Chirantan Upadhyay (Top 4 by date)

please look at your code carefully. initially it looks bad. Dept Table will have DeptNo and Dept name. Employee table will have EmpNo, EmpName and DeptNo. DeptNo will work as Relation "DeptEmp". now traverse Dept Table and get childs by GetChildRows. then add all these values DeptNo,EmpNo, EployeeName in Combined Table (DeptNo,Empno,EmpName).
also there are so many objest so let me know in which line there is error. obviously looks it will be with dt1 or dt2 . because i can't see instance creation using new or adding columns etc.