protected void btndelcat_Click(object sender, EventArgs e) { //delete all data from products in that category string str = ddlcat.SelectedItem.ToString(); bool check1 = dba.deleteProductFromCat(str); // delete category bool check = false; if (check1) { check = dba.deleteCategory(str); } if (check) { lblstat2.Text = "Category Deleted!"; } else { lblstat2.Text = "Eror! Category Not Deleted!"; } //refresh dropdown list if ((!Page.IsPostBack)) { DataTable dt1 = dba.getAllCategories(); ddlcat.DataSource = dt1; ddlcat.DataValueField = "cname"; ddlcat.DataTextField = "cname"; ddlcat.DataBind(); } }