private void ultraBtnDelete_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure you want to delete?", "delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { objHospitalDB = new HospitalDB(); Doctor objDoctor = new Doctor(objHospitalDB); DoctorRow objDoctorRow = new DoctorRow(); objDoctorRow.Doctor_ID = Convert.ToInt32(this.id); objDoctor.Delete(objDoctorRow); ultraGridDoc.DataSource = objDoctor.GetAll(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } /*try * { * objHospitalDB = new HospitalDB(); * // con.Open(); * ultraGridDoc.Rows[this.ultraGridDoc.ActiveRow.Index].Delete(true); * SqlCommand query = objHospitalDB.CreateCommand("delete from Doctor where Doctor_ID='" + this.id + "';", false); * int p = query.ExecuteNonQuery(); * * MessageBox.Show(p + "Deleted"); * } * catch (Exception ex) * { * MessageBox.Show(ex.Message); * if(objHospitalDB!=null) * { * objHospitalDB.Dispose(); * } * }*/ }