private SqlConnection sql;
        private DataGridView dgw;
        private SqlDataAdapter sqAdpt;
        private DataSet ds;

            // заполнение родительской таблицы
            string cmd = String.Format("select id, name as 'Наименование' from {0}", tableName);
            sqAdpt = new SqlDataAdapter();
            sqAdpt.SelectCommand = new SqlCommand(cmd, sql);
            SqlCommandBuilder builder = new SqlCommandBuilder(sqAdpt);
            ds = new DataSet();
            sqAdpt.Fill(ds, tableName);

            // заполнение дочерней таблицы (отношение id - index)
            cmd = "select [name], [index] from [directory]";
            sqAdpt.SelectCommand = new SqlCommand(cmd, sql);
            SqlCommandBuilder builder2 = new SqlCommandBuilder(sqAdpt);
            sqAdpt.Fill(ds, "directory");
            
            //создание отоношения
            DataColumn parent =  ds.Tables[tableName].Columns["id"] ;
            DataColumn child =  ds.Tables["directory"].Columns["index"] ;
            DataRelation dr = new DataRelation("directoryR",parent, child);
            ds.Relations.Add(dr);
			
            dgw.DataSource = ds.Tables[tableName];