Как сохранять данные в БД 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, могу там добавлять/изменять/удалять данные, но они не сохраняются в базе.