示例#1
0
        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();
            }
        }