Как сохранять данные в БД Sql вносимые через DataGrid

Столкнулся с проблемой. Вывожу данные из бд в Datagrid. Как сделать так, чтобы данные которые я ввожу через сам DataGrid во время работы приложения, сохранялись в бд?

Код вывода в Datagrid

private void ComboBoxChange_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            switch (ComboBoxChange.SelectedIndex)
            {
                case 0:
                    string connectionString = @"Data Source=userPC;Initial Catalog=AutoService;Integrated Security=True";
                    string sql = "SELECT * FROM Автомобиль";
                    using (SqlConnection connection = new SqlConnection(connectionString))
                    {
                        connection.Open();
                        SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
                        DataSet ds = new DataSet();
                        adapter.Fill(ds);
                        DataGridAuto.ItemsSource = ds.Tables[0].DefaultView;
                        DataGridAuto.Visibility = Visibility.Visible;
                        DataGridMasters.Visibility = Visibility.Hidden;
                        DataGridApplication.Visibility = Visibility.Hidden;
                        DataGridClient.Visibility = Visibility.Hidden;
                        break;
                    }
                case 1:
                    string connectionString1 = @"Data Source=userPC;Initial Catalog=AutoService;Integrated Security=True";
                    string sql1 = "SELECT * FROM Клиент";
                    using (SqlConnection connection1 = new SqlConnection(connectionString1))
                    {
                        connection1.Open();
                        SqlDataAdapter adapter1 = new SqlDataAdapter(sql1, connection1);
                        DataSet ds1 = new DataSet();
                        adapter1.Fill(ds1);
                        DataGridClient.ItemsSource = ds1.Tables[0].DefaultView;
                        SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter1);
                        adapter1.Update(ds1, "Table");
                        ds1.Clear();
                        adapter1.Fill(ds1);
                        DataGridClient.ItemsSource = ds1.Tables[0].DefaultView;
                        DataGridAuto.Visibility = Visibility.Hidden;
                        DataGridMasters.Visibility = Visibility.Hidden;
                        DataGridApplication.Visibility = Visibility.Hidden;
                        DataGridClient.Visibility = Visibility.Visible;
                        break;
                    }
                case 2:
                    string connectionString2 = @"Data Source=userPC;Initial Catalog=AutoService;Integrated Security=True";
                    string sql2 = "SELECT * FROM Заявка";
                    using (SqlConnection connection2 = new SqlConnection(connectionString2))
                    {
                        connection2.Open();
                        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, connection2);
                        DataSet ds2 = new DataSet();
                        adapter2.Fill(ds2);
                        DataGridApplication.ItemsSource = ds2.Tables[0].DefaultView;
                        DataGridAuto.Visibility = Visibility.Hidden;
                        DataGridMasters.Visibility = Visibility.Hidden;
                        DataGridApplication.Visibility = Visibility.Visible;
                        DataGridClient.Visibility = Visibility.Hidden;
                        break;
                    }
                case 3:
                    string connectionString3 = @"Data Source=userPC;Initial Catalog=AutoService;Integrated Security=True";
                    string sql3 = "SELECT * FROM Мастер";
                    using (SqlConnection connection3 = new SqlConnection(connectionString3))
                    {
                        connection3.Open();
                        SqlDataAdapter adapter3 = new SqlDataAdapter(sql3, connection3);
                        DataSet ds3 = new DataSet();
                        adapter3.Fill(ds3);
                        DataGridMasters.ItemsSource = ds3.Tables[0].DefaultView;
                        DataGridAuto.Visibility = Visibility.Hidden;
                        DataGridMasters.Visibility = Visibility.Visible;
                        DataGridApplication.Visibility = Visibility.Hidden;
                        DataGridClient.Visibility = Visibility.Hidden;
                        break;
                    }
            }
        }

На данный момент, при запуске приложения через ComboBox могу выбрать нужную мне таблицу, выводится её DataGrid, могу там добавлять/изменять/удалять данные, но они не сохраняются в базе.


Ответы (0 шт):