Форум программистов [Powered by Invision Power Board]

Код

try
            {
                sqlcon.Open();
                SqlDataAdapter DA_employees = new SqlDataAdapter("SELECT * FROM employees", sqlcon);
                SqlDataAdapter DA_depsubunits = new SqlDataAdapter("SELECT * FROM depsubunits", sqlcon);
                DataSet DS = new DataSet();
                DA_employees.Fill(DS, "Employees");
                DA_depsubunits.Fill(DS, "DepSubunits");
                DataRelation rel = DS.Relations.Add("DepSubunits_Employees", DS.Tables["DepSubunits"].Columns["id"], DS.Tables["Employees"].Columns["subunitcode"]);
                DS.Relations.Add(rel);
                foreach (DataRow rowDepSubunit in DS.Tables["DepSubunits"].Rows) 
                {
                    Console.WriteLine("{0} {1}", rowDepSubunit["number"], rowDepSubunit["name"]);
                    foreach (DataRow rowEmployee in rowDepSubunit.GetChildRows(rel))
                    {
                        Console.WriteLine(" {0} {1} {2} {3}",rowEmployee["tablenumber"],rowEmployee["middlename"],rowEmployee["firstname"],rowEmployee["lastname"]);
                        Console.WriteLine();
                    }
                }
            }