//deletes row if found private void DeleteButton_Click(object sender, EventArgs e) { var confirmResult = MessageBox.Show("Are you sure to delete this Appointment?", "Confirm Delete?", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { if (AppIndx >= 0) { FormModel.DeleteNonQuery($"delete from appointment where appointmentID = '{AppointmentsDGV.Rows[(int)AppIndx].Cells[0].Value.ToString()}';"); AppointmentSelectTableLoad(); } } }
private void DeleteButton_Click(object sender, EventArgs e) { var confirmResult = MessageBox.Show("Are you sure to delete this Customer?", "Confirm Delete!", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { foreach (DataRow row in returnedSelectTable.Rows) { if (IDTextBox.Text == row.ItemArray[0].ToString()) { row.Delete(); CustIndx = null; FormModel.DeleteNonQuery($"delete from customer where customerID = '{IDTextBox.Text}'; Commit;"); } } } }