I have the following code where Build the relation on DataSet Schema I got
the error that Child Has Multiple Tables
DataTable LoData = new DataTable("LearningOutcomesDT");
DataTable LoDocData = new DataTable("LearningOutcomesDocDT");
da = new SqlDataAdapter(BuildSQLQuery(BookId,queryType.LOBo ok),oSql);
da.Fill(LoData);
ds.Tables.Add(LoData);
da = new SqlDataAdapter(BuildSQLQuery(BookId,queryType.LODo c),oSql);
da.Fill(LoDocData);
ds.Tables.Add(LoDocData);
DataRelation oLORelation =
ds.Relations.Add("ThesisLODocRelation",ds.Tables[0].Columns["ThesisID"],
ds.Tables["LearningOutcomesDT"].Columns["ThesisID"],false);
DataRelation oDocRelation =
ds.Relations.Add("ThesisLORelation",ds.Tables["LearningOutcomesDT"].Columns["LOID"],
ds.Tables["LearningOutcomesDocDT"].Columns["LOID"],false);
oDocRelation.Nested = true;//Error Occured When I added this line
oLORelation.Nested = true;
How can I solve this problem