private void btn2_Click(object sender, RoutedEventArgs e) { string strsql = "DELETE FROM Categories WHERE CategoryID=1"; Под.Updates(strsql); string strsql1 = "SELECT * FROM Categories cat JOIN Goods g ON g.Category = cat.CategoryID"; DataTable ds = Подключение.Selects(strsql1); dgr1.ItemsSource = ds.AsDataView(); }
private void btn3_Click(object sender, RoutedEventArgs e) { string PrName = "Карамель"; Double PrName1 = 25; int PrName2 = 965; //string strsql = "SELECT * FROM Goods"; string strsql = "INSERT INTO Goods(Category,ProductName,Price,Количество) VALUES (2,'" + PrName + "'," + PrName1 + "," + PrName2 + ")"; Под.Updates(strsql); string strsql1 = "SELECT * FROM Goods"; DataTable ds = Подключение.Selects(strsql1); grid1.ItemsSource = ds.AsDataView(); }