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

Код

        public Form1()
        {
            InitializeComponent();

            DataSet dataSet = new DataSet();

            DataTable tableA = dataSet.Tables.Add("A");
            DataColumn colA_Id = tableA.Columns.Add("ID", typeof(int));
            colA_Id.AllowDBNull = false;
            tableA.Columns.Add("Name", typeof(string));

            DataTable tableB = dataSet.Tables.Add("B");
            DataColumn colB_Id = tableB.Columns.Add("ID", typeof(int));
            colB_Id.AutoIncrement = true;
            colB_Id.AllowDBNull = false;
            DataColumn colB_AId = tableB.Columns.Add("AID", typeof(int));
            colB_AId.AllowDBNull = false;
            tableB.Columns.Add("Name", typeof(string));

            tableA.Rows.Add(1, "str1");
            tableA.Rows.Add(2, "str2");
            tableA.Rows.Add(3, "str3");

            tableB.Rows.Add(null, 1, "str1-1");
            tableB.Rows.Add(null, 1, "str1-2");
            tableB.Rows.Add(null, 1, "str1-3");
            tableB.Rows.Add(null, 2, "str2-1");
            tableB.Rows.Add(null, 2, "str2-2");
            tableB.Rows.Add(null, 3, "str3-1");

            dataSet.Relations.Add("A2B", colA_Id, colB_AId);

            // вариант 1
            BindingSource sourceTableA = new BindingSource();
            sourceTableA.DataSource = dataSet;
            sourceTableA.DataMember = "A";

            BindingSource sourceChild = new BindingSource();
            sourceChild.DataSource = sourceTableA;
            sourceChild.DataMember = "A2B";

            dataGridView1.DataSource = sourceTableA;
            dataGridView2.DataSource = sourceChild;
            // вариант 1 //

            // вариант 2 (без BindingSource)
            // dataGridView1.DataSource = tableA.DefaultView;
            // dataGridView2.DataSource = tableA.DefaultView;
            // dataGridView2.DataMember = "A2B";
            // вариант 2 //
        }