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