grid_MD_USER_GRUPPE.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
                grid_MD_USER_GRUPPE.AllowUserToAddRows = false;
                grid_MD_USER_GRUPPE.AutoGenerateColumns = false;
                grid_MD_USER_GRUPPE.ReadOnly = true;
                grid_MD_USER_GRUPPE.AddTextColumn("GRUPPE", "Gruppe"); // свой метод добавляет колонку с заголовком
                grid_MD_USER_GRUPPE.DataSource = bs_MD_USER_GRUPPE;

                lst_MD_USER_GRUPPE.DataSource = bs_MD_USER_GRUPPE;
                lst_MD_USER_GRUPPE.DisplayMember = "GRUPPE";
                lst_MD_USER_GRUPPE.ValueMember = "SATZ_ID";

using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace DataRelationApplication
{
    public partial class Form1 : Form
    {
        private BindingSource masterBindingSource = new BindingSource();
        private DataGridView masterDataGridView = new DataGridView();
        private BindingSource detailsBindingSource = new BindingSource();
        // private DataGridView detailsDataGridView = new DataGridView();
        private ListBox detailsListBox = new ListBox();

        public Form1()
        {
            masterDataGridView.Dock = DockStyle.Fill;
            // detailsDataGridView.Dock = DockStyle.Fill;
            detailsListBox.Dock = DockStyle.Fill;

            SplitContainer splitContainer1 = new SplitContainer();
            splitContainer1.Dock = DockStyle.Fill;
            splitContainer1.Orientation = Orientation.Horizontal;
            splitContainer1.Panel1.Controls.Add(masterDataGridView);
            // splitContainer1.Panel2.Controls.Add(detailsDataGridView);
            splitContainer1.Panel2.Controls.Add(detailsListBox);

            this.Controls.Add(splitContainer1);
            this.Text = "DataGridView master/detail demo";
        }

        protected override void OnLoad(System.EventArgs e)
        {
            base.OnLoad(e);

            // Bind the DataGridView controls to the BindingSource components and load the data from the database.
            masterDataGridView.DataSource = masterBindingSource;
            // detailsDataGridView.DataSource = detailsBindingSource;

            GetData();

            detailsListBox.DataSource = detailsBindingSource;
            detailsListBox.DisplayMember = "SalesOrderNumber";
            detailsListBox.ValueMember = "SalesOrderID";

            // Resize the master DataGridView columns to fit the newly loaded data.
            masterDataGridView.AutoResizeColumns();

            // Configure the details DataGridView so that its columns automatically adjust their widths when the data changes.
            // detailsDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
        }

        private void GetData()
        {
            try
            {
                // Specify a connection string. Replace the given value with a valid connection string for a Northwind SQL Server sample database accessible to your system.
                var connectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks;Data Source=localhost";
                SqlConnection connection = new SqlConnection(connectionString);

                // Create a DataSet.
                var data = new DataSet { Locale = System.Globalization.CultureInfo.InvariantCulture };

                // Add data from the Customers table to the DataSet.
                var masterDataAdapter = new SqlDataAdapter("select * from Sales.Customer where CustomerID > 10999", connection);
                masterDataAdapter.Fill(data, "Customers");

                // Add data from the Orders table to the DataSet.
                var detailsDataAdapter = new SqlDataAdapter("select * from Sales.SalesOrderHeader", connection);
                detailsDataAdapter.Fill(data, "Orders");

                // Establish a relationship between the two tables.
                var relation = new DataRelation("CustomersOrders", data.Tables[ "Customers" ].Columns[ "CustomerID" ], data.Tables[ "Orders" ].Columns[ "CustomerID" ]);
                data.Relations.Add(relation);

                // Bind the master data connector to the Customers table.
                masterBindingSource.DataSource = data;
                masterBindingSource.DataMember = "Customers";

                // Bind the details data connector to the master data connector,
                // using the DataRelation name to filter the information in the details table based on the current row in the master table.
                detailsBindingSource.DataSource = masterBindingSource;
                detailsBindingSource.DataMember = "CustomersOrders";
            }
            catch (SqlException)
            {
                MessageBox.Show("To run this example, replace the value of the connectionString variable with a connection string that is valid for your system.");
            }
        }
    }
}