protected void btnDelete_Click(object sender, EventArgs e) { lblEMsg.Visible = false; Profile pro = new Profile(); try { if (lstid.SelectedItem.Text == "") { lblEMsg.Text = "Please select Author ID"; lblEMsg.Visible = true; } else { bool status; status = pro.DeleteAuthor(lstid.SelectedItem.Text); if (status == false) { lblEMsg.Visible = true; lblEMsg.Text = "Author deletion Failed"; } lblEMsg.Visible = true; lblEMsg.Text = "Author deleted."; lstid.Items.Clear(); //Load all the Category First. string sql = "SELECT Author_ID FROM Author Where Status ='A'"; SqlDataReader sdr; sdr = pro.ReturnMDetails(sql); while (sdr.Read()) { lstid.Items.Add(sdr["Author_ID"].ToString().Trim()); } sdr.Close(); txtAName.Text = ""; txtAdd.Text = ""; txtPhone.Text = ""; txtFax.Text = ""; txtEmail.Text = ""; chkStatus.Checked = false; return; } } catch (Exception ex) { throw ex; } }