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(); }