protected void Page_Load(object sender, EventArgs e) { using (eShopperDBEntities products = new eShopperDBEntities()) { var query = from p in products.tProducts select p; tProduct product = (query.FirstOrDefault <tProduct>()); GridView1.DataSource = query.ToList(); GridView1.DataBind(); } using (eShopperDBEntities categpry = new eShopperDBEntities()) { var query = (from c in categpry.tCategories select c); // tCategory categpryies = (query.FirstOrDefault<tCategory>()); // GridView1.DataSource = query.ToList(); // GridView1.DataBind(); DropDownList2.DataSource = query.ToList(); DropDownList2.DataTextField = "CategoryName"; DropDownList2.DataValueField = "CategoryID"; DropDownList2.DataBind(); } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { int min = Convert.ToInt32(TextBox1.Text); int max = Convert.ToInt32(TextBox2.Text); if (DropDownList1.SelectedIndex < 9) { using (eShopperDBEntities products = new eShopperDBEntities()) { var query = from p in products.tProducts where p.CategoryID == DropDownList1.SelectedIndex + 1 where p.Price >= min where p.Price <= max select p; tProduct product = (query.FirstOrDefault <tProduct>()); GridView1.DataSource = query.ToList(); GridView1.DataBind(); } } else { using (eShopperDBEntities products = new eShopperDBEntities()) { var query = from p in products.tProducts where p.Price >= min where p.Price <= max select p; tProduct product = (query.FirstOrDefault <tProduct>()); GridView1.DataSource = query.ToList(); GridView1.DataBind(); } } }