private void Window_Loaded(object sender, RoutedEventArgs e) { World_yachts.World_yachts_KisinDataSet1 world_yachts_KisinDataSet1 = ((World_yachts.World_yachts_KisinDataSet1)(this.FindResource("world_yachts_KisinDataSet1"))); // Загрузить данные в таблицу Клиенты. Можно изменить этот код как требуется. World_yachts.World_yachts_KisinDataSet1TableAdapters.КлиентыTableAdapter world_yachts_KisinDataSet1КлиентыTableAdapter = new World_yachts.World_yachts_KisinDataSet1TableAdapters.КлиентыTableAdapter(); world_yachts_KisinDataSet1КлиентыTableAdapter.Fill(world_yachts_KisinDataSet1.Клиенты); System.Windows.Data.CollectionViewSource клиентыViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("клиентыViewSource"))); клиентыViewSource.View.MoveCurrentToFirst(); }
private void Button_Click(object sender, RoutedEventArgs e) { string del = клиентыDataGrid.SelectedCells[0].ToString(); string cmdStr = "DELETE FROM dbo.Клиенты WHERE Наименование_клиента = '" + del + "';"; SqlCommand cmdinst = new SqlCommand(cmdStr, Conn); cmdinst.ExecuteNonQuery(); Conn.Close(); World_yachts.World_yachts_KisinDataSet1TableAdapters.КлиентыTableAdapter world_yachts_KisinDataSet1КлиентыTableAdapter = new World_yachts.World_yachts_KisinDataSet1TableAdapters.КлиентыTableAdapter(); }