private void MakeDataRelation()
{
DataColumn parentColumn = _dataSet.Tables["ParentTable"].Columns["id"];
DataColumn childColumn = _dataSet.Tables["ChildTable"].Columns["ParentID"];
DataRelation relation = new DataRelation("ParentChild_Relation1", parentColumn, childColumn);
_dataSet.Tables["ChildTable"].ParentRelations.Add(relation);
DataColumn[] parentColumn1 = new DataColumn[2];
DataColumn[] childColumn1 = new DataColumn[2];
parentColumn1[0] = _dataSet.Tables["ParentTable"].Columns["id"];
parentColumn1[1] = _dataSet.Tables["ParentTable"].Columns["DepartmentID"];
childColumn1[0] = _dataSet.Tables["SecondChildTable"].Columns["ParentID"];
childColumn1[1] = _dataSet.Tables["SecondChildTable"].Columns["DepartmentID"];
DataRelation secondRelation = new DataRelation("ParentChild_Relation2", parentColumn1, childColumn1);
_dataSet.Tables["SecondChildTable"].ParentRelations.Add(secondRelation);
}