private void btnDelete_Click(object sender, EventArgs e) { bool CHK = DBLayer.CHK_B4_DEL_ORAKH(txtName.Text); if (CHK) { MessageBox.Show("Cannot Delete! Already in use", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DialogResult result = MessageBox.Show("Are You Sure You Want to Delete", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { usp_SEL_tblOrakhTableAdapter.Delete1(Convert.ToInt32(txtID.Text)); usp_SEL_tblOrakhTableAdapter.Fill(comDataSet.usp_SEL_tblOrakh); MessageBox.Show("Deleted Successfully!", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }