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