public void GetBrandByProduct() { Object FillBrand = new Object(); FillBrand.Product_Name = HiddenProductName.Value; FillBrand.Category_Name = HiddenCatagoryName.Value; DataTable dt = BSLAYER.BrandFill(FillBrand); DdlBrand.DataSource = dt; DdlBrand.DataTextField = "Product_Brand"; DdlBrand.DataValueField = "Product_Brand"; DdlBrand.DataBind(); DdlBrand.Items.Insert(0, "--SORT BY BRAND--"); }
private void BindBrand() { using (SqlConnection con = new SqlConnection(ConnectString)) { con.Open(); SqlCommand cmd = new SqlCommand("Select * from Tbl_Brands", con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count != 0) { DdlBrand.DataSource = dt; DdlBrand.DataTextField = "Name"; DdlBrand.DataValueField = "BrandId"; DdlBrand.DataBind(); } } }