Create a relationship between two DataSet tables

Create a relationship between two DataSet tables

The DataRelation class is used to joins tables in DataSet. You can found DataRelation class within the System.Data namespace. Each relationship includes a parent and a child. Add two tables one for parent and another one for child to your DataSet to create a relationship between them. Then create a new DataRelation instance, passing its constructor the name of the new relationship, plus a reference to the linking columns in each table.


  DataSet objDS = new DataSet();



            DataRelation objRelation = new DataRelation("objRelation",

            Employee.Columns["EmpID"], Department.Columns["EmpID"]);



In above example we are joining an Employee table with a Department table, linking the Employee.EmpID column as the parent with the related Department.EmpID column as the child