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