private void bindGridView() { LastADEntities entities = new LastADEntities(); var q = entities.RequDetails.GroupBy(x => x.ItemId).Select(x => new{ ItemId = x.Key, TotalRQ = x.Sum(p => p.RequestedQuantity) }) .OrderByDescending(p => p.TotalRQ).Take(10).ToList(); for (int i = 0; i < q.Count; i++) { il.Add(Business.FinditemobjByID(q[i].ItemId.ToString())); } ; GridView1.DataSource = il; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["itemidlist"] != null) { list2 = (ArrayList)Session["itemidlist"]; } if (!IsPostBack) { for (int i = 0; i < list2.Count; i++) { list.Add(Business.FinditemobjByID(list2[i].ToString())); } GridView1.DataSource = list; GridView1.DataBind(); } }