void LoadAllMainCatagoryInDropDowmList() { DropDownListCatagory.DataSource = addNewProductManagerObj.BindAllMainCatagory(); DropDownListCatagory.DataValueField = "CatagoryID"; DropDownListCatagory.DataTextField = "CatagoryName"; DropDownListCatagory.DataBind(); DropDownListCatagory.Items.Insert(0, new ListItem("--Select--", "0")); }
protected void LodaCatagory() { using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("SELECT CatagoryID, CatagoryName FROM ProductCatagory", con); con.Open(); DropDownListCatagory.DataSource = cmd.ExecuteReader(); DropDownListCatagory.DataTextField = "CatagoryName"; DropDownListCatagory.DataValueField = "CatagoryID"; DropDownListCatagory.DataBind(); ListItem liCatagory = new ListItem("Select Product Catagory", "-1"); DropDownListCatagory.Items.Insert(0, liCatagory); } }