protected void Page_Load(object sender, EventArgs e) { using (BSEntities Db = new BSEntities()) { ddl.DataSource = Db.cities.Select(x => x.name).ToList(); ddl.DataBind(); } }
protected void btnSearch_Click(object sender, ImageClickEventArgs e) { using (BSEntities Db = new BSEntities()) { Session["src"] = (from r in Db.books where r.author.fname.Contains(tbSearch.Text) || r.name.Contains(tbSearch.Text) || r.category.name.Contains(tbSearch.Text) select new { id = r.id, name = r.name, category = r.category.name, description = r.description, author = r.author.fname + " " + r.author.lname, count = r.count, price = r.price + " " + r.valute.name, image_url = r.image_url }).ToList(); Response.Redirect("books_view.aspx"); } }