if (string.IsNullOrWhiteSpace(Regno.Text)) { MessageBox.Show("Id Field Is Empty First Click On Datagrid Cell To populate it with a value"); } else { string deleteSQLQuery = "DELETE FROM tbl_member WHERE RegNo=@regno"; SqlCommand deleteCommand; try { //Open Database Connection connection.OpenDBConnection(); deleteCommand = new SqlCommand(deleteSQLQuery, connection.getDatabaseConnection()); deleteCommand.Parameters.Add("@regno", SqlDbType.Int).Value = int.Parse(Regno.Text); //Check If The Data has been deleted if (deleteCommand.ExecuteNonQuery() == 1) { //MessageBox.Show("Data Deleted Successfully..... "); } } catch (Exception err) { MessageBox.Show("Err " + err); } finally { //close Database Connection connection.CloseDBConnection(); } //clear input fields after Deleting data from mysql database clearFields(); //Refresh datagridview after deleting data from database refreshDatagridView(""); }
ADD THIS line
(MessageBox.Show("Do You Need To Delete Data Of Member Register :- " + Regno.Text.ToString() + "", "Member Register", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) MessageBox.Show("Row Not Remove", "Remove Row", MessageBoxButtons.OK, MessageBoxIcon.Information);