Dataset Relations within the same table ... seeking advice

Question

Hello all Pretty new to programming here but I seem to be moving along quite well. I have a specific situation I need advice on. I'll use a hypothetical example: Let's say we have a table that holds a person's detailed information. Of course every single unique indivual is entered into the table only once. Now under teh columns of Mother and Father there is a user id referenceing the respective records of the people who are the father and the mother. Here comes the question ... I fill a dataset (datset because there are other tables no mentioned in the example that need to be in there) with all the people that belong to a certain groud for example all of a specific teacher's students or a doctor's patients etc. This means that in this table we have very likely left out the records of the parents of each of these students and/or patients. How (if it's even possible) can a relationship be establishied whitin the dataset without having to load the entire people table which contains thousands of records? My idea was to first load the original query (a teacher's students) and the transverse the table and appending rows as each father and mother got looked up but this seems inneficient to me with allt he checks and calls needed. Anyway I know this is very vague but I hope my question makes sense. I am just trying to get an idea of what the best pratice is for a scenario like this one.

send2manivannan · Answer

using System; using System.Data; public class A { public static void Main() { DataSet Ds=new DataSet(); Ds.Tables.Add(new DataTable()); Ds.Tables[0].Columns.Add(EmpCode); Ds.Tables[0].Columns.Add(EmpName); Ds.Tables[0].Columns.Add(Manager); Ds.Relations.Add(new DataRelation(Emp2ManagerDs.Tables[0].Columns[0]Ds.Tables[0].Columns[2])); DataRow newRow; newRow = Ds.Tables[0].NewRow(); newRow[0]=1; newRow[1]=MD; newRow[2]=null; Ds.Tables[0].Rows.Add(newRow); newRow = Ds.Tables[0].NewRow(); newRow[0]=2; newRow[1]=Manager; newRow[2]=1; Ds.Tables[0].Rows.Add(newRow); newRow = Ds.Tables[0].NewRow(); newRow[0]=3; newRow[1]=Assit. Manager; newRow[2]=2; Ds.Tables[0].Rows.Add(newRow); newRow = Ds.Tables[0].NewRow(); newRow[0]=4; newRow[1]=Finance Manager; newRow[2]=1; Ds.Tables[0].Rows.Add(newRow); for(int i=0;i 0) { Console.WriteLine({0}'s Manager is {1}Ds.Tables[0].Rows[i][1]dv[0][1]); } else { Console.WriteLine({0}'s Do't have Any ManagerDs.Tables[0].Rows[i][1]); } } } }