protected void btnDelete_Click(object sender, EventArgs e) { lblEMsg.Visible = false; Profile pro = new Profile(); try { if (lstbook.SelectedItem.ToString() == "") { lblEMsg.Text = "Please select Book No"; lblEMsg.Visible = true; } else { bool status; status = pro.DeleteBook(lstbook.SelectedItem.ToString()); if (status == false) { lblEMsg.Visible = true; lblEMsg.Text = "Book deletion Failed"; } lblEMsg.Visible = true; lblEMsg.Text = "Book deleted."; lstbook.Items.Clear(); //Load all the Publisher First. string sql = "SELECT Book_ID FROM Book_Master where Status = 'A'"; SqlDataReader sdr; sdr = pro.ReturnMDetails(sql); lstbook.Items.Add(""); while (sdr.Read()) { lstbook.Items.Add(sdr["Book_ID"].ToString().Trim()); } sdr.Close(); txtBTitle.Text = ""; LstAuthor.Text = ""; LstCategory.Text = ""; LstPublisher.Text = ""; LstSupplier.Text = ""; txtKey.Text = ""; txtIsbn.Text = ""; txtQuantity.Text = ""; txtPrice.Text = ""; chkStatus.Checked = false; lblEMsg.Visible = false; } } catch (Exception ex) { throw ex; } }