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