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();
}
}
}
