DataSet ds = new DataSet();
        public int PreviousPage { get; set; }
        MySqlDataAdapter adapter;
        readonly string connectionString = "server=localhost;user=root;database=a_stroy;password=q1w2e3r4t5y6u7i8o9p0;";
        public DataTable Execute(string script)
        {
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                DataTable table = new DataTable();
                connection.Open();
                adapter = new MySqlDataAdapter(script, connection);
                adapter.Fill(table);
                return table;
            }
        }

        private void СomboBox1_SelectedValueChanged(object sender, EventArgs e)
        {
            dataGridView1.Rows.Clear();
            if (comboBox1.SelectedValue != null)
            {
                column1.DataSource = Execute($"SELECT id_Object, id_customer, Name_object FROM a_stroy.object where id_customer = {comboBox1.SelectedValue};");
                column1.DisplayMember = "Name_object";
                column1.ValueMember = "id_Object";
            }
        }

        private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            ComboBox cbDgv = e.Control as ComboBox;
            cbDgv.SelectedValueChanged -= new EventHandler(CbDgv_SelectedValueChanged);
            cbDgv.SelectedValueChanged += new EventHandler(CbDgv_SelectedValueChanged);
        }

        private void CbDgv_SelectedValueChanged(object sender, EventArgs e)
        {
            dataGridView1.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(dataGridView1_EditingControlShowing);
            int rows = dataGridView1.Rows.Count;
            var comboBox = (DataGridViewComboBoxEditingControl)sender;
            int rowIndex = comboBox.EditingControlRowIndex;
            var query = $"SELECT id_Object, Name_works FROM a_stroy.words_object where id_Object = {rowIndex}"; // получение данных из combobox 
            column2.DataSource = Execute(query);
            column2.DisplayMember = "Name_works";
            column2.ValueMember = "id_Object";
            Debug.WriteLine(rowIndex);
            Debug.WriteLine(rows);
            
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                DataSet sp_CreateUser = new DataSet("id_Object");
                DataTable sp_CreateUser1 = new DataTable("sp_CreateUser1");
                sp_CreateUser.Tables.Add(sp_CreateUser1); // добавляем таблицу в dataset
                DataColumn nameColumn = new DataColumn("id_Object", Type.GetType("System.String"));
                string mysql = "SELECT * FROM Users";
                connection.Open();
                adapter = new MySqlDataAdapter(mysql, connection);
                MySqlCommandBuilder commandBuilder;
                commandBuilder = new MySqlCommandBuilder(adapter);
                adapter.InsertCommand = new MySqlCommand("id_Object", connection);
                adapter.InsertCommand.CommandType = CommandType.StoredProcedure;
                MySqlParameter parameter = adapter.InsertCommand.Parameters.Add("@id_Object", MySqlDbType.VarChar, 0, "Id");
                parameter.Direction = ParameterDirection.Output;
                adapter.Update(ds, "id_Object");
            }
        Debug.WriteLine(ds, "id_Object");
        }