ProductList.aspx

This screen comes after one selects the product subcategories in the showbrands.aspx.

The code is simple .Only thing is to capture the brandid from showbrands page.

private void Page_Load(object sender, System.EventArgs e)

{

Session["fullname"]="";

int brandid = Int32.Parse(Request.Params["brandID"]);

SqlConnection scon = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

SqlDataAdapter prodadapter = new SqlDataAdapter("Select im.imagename,im.images,pr.modelnumber,pc.categoryname,pr.modelname,pr.productid,pr.unitcost,pr.description from images im,products pr,productcategories pc where im.productid = pr.productid and pc.categoryid = pr.categoryid and pr.internalproductsubcategoryid ='" + brandid +"'",scon);

DataSet ds = new DataSet();

prodadapter.Fill(ds);

Prodlist.DataSource = ds;

Prodlist.DataBind();

}