private void bt_Delete_Click(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("คุณต้องการลบข้อมูลที่เช็คหรือไม่", "ลบข้อมูลนี้แล้ว", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { for (int i = 0; i < dataGrid.Items.Count; i++) { DataGridRow item = (DataGridRow)this.dataGrid.ItemContainerGenerator.ContainerFromItem(dataGrid.Items[i]); CheckBox cbkdel = (CheckBox)GetVisualChild <CheckBox>(item); if (cbkdel.IsChecked.Value) { object itemz = dataGrid.Items[i]; string showid = (dataGrid.SelectedCells[9].Column.GetCellContent(itemz) as TextBlock).Text; con.Open(); string sql = "DELETE from checkwork where checkworkID='" + showid + "'"; MySqlCommand cmd = new MySqlCommand(sql, con); cmd.ExecuteNonQuery(); con.Close(); } } MessageBox.Show("ลบเรียบร้อยแล้ว!!!"); this.Close(); ManageCheckwork go = new ManageCheckwork(); go.Show(); } } //ปิด Event Delete
private void MenuItem3_Click(object sender, RoutedEventArgs e) { ManageCheckwork go = new ManageCheckwork(); go.Show(); }