Использование объектов ADO.NET для работы с базами данных. Приложение баз данных на основе Windows-форм, соответствующее предметной области, страница 6

                dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[3].Value = cbUsluga.SelectedValue;

            }

        }

        private void button1_Click(object sender, EventArgs e)

        {

            try

            {

                if (oleDbDataAdapter_orders != null)

                    oleDbDataAdapter_orders.Update(dataSet_orders1, "Заказы");

                MessageBox.Show("Изменения в таблице \"Заказы\" успешно сохранены.",

                    "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            catch (Exception exp)

            {

                MessageBox.Show("Ошибка сохраненения.",

                    "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

        }

}

public partial class Client : Form

    {

        public Client()

        {

            InitializeComponent();

        }

        private void Client_Load(object sender, EventArgs e)

        {

            oleDbDataAdapter_cbNational.Fill(dataSet_cbDataNational1);

            oleDbDataAdapter_cbLabel.Fill(dataSet_cbLabel1);

            RefreshClients();

        }

        private void RefreshClients()

        {

            dataSet_clients1.Clear();

            if (cbNational.SelectedIndex != 1 && cbLabel.SelectedIndex != 1)

            {

                oleDbDataAdapter_clients.SelectCommand.Parameters[0].Value = cbLabel.SelectedValue;

                oleDbDataAdapter_clients.SelectCommand.Parameters[1].Value = cbNational.SelectedValue;

                oleDbDataAdapter_clients.Fill(dataSet_clients1);

            }

        }

        private void cbNational_SelectedIndexChanged(object sender, EventArgs e)

        {

            RefreshClients();

        }

        private void cbLabel_SelectedIndexChanged(object sender, EventArgs e)

        {

            RefreshClients();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            try

            {

                if (oleDbDataAdapter_clients != null)

                    oleDbDataAdapter_clients.Update(dataSet_clients1, "Клиенты");

                MessageBox.Show("Изменения в таблице \"Клиенты\" успешно сохранены.",

                    "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            catch (Exception exp)

            {

                MessageBox.Show("Ошибка сохраненения.",

                    "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

        }

        private void dataGridView1_SelectionChanged(object sender, EventArgs e)

        {

            if (dataGridView1.SelectedCells.Count > 0)

            {

                dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[12].Value = cbLabel.SelectedValue;

                dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[13].Value = cbNational.SelectedValue;

            }

        }

}