web 第五题

根据名称分组并显示产品名为 ** 的集合：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class five : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void BthGroup_Click(object sender, EventArgs e)
    {
        MyPetShopEntities db = new MyPetShopEntities();
        var results = db.Table.GroupBy(p => p.CategoryId);
        foreach (var g in results)
        {
            if(g.Key == "5")
            {
                var results2 = from r in g select r;
                gvCategory.DataSource = results2.ToList();
                gvCategory.DataBind();
            }
        }
    }
}

根据产品名称分组统计每组的个数，并计算某产品的最大值

protected void btnPolymerize_Click(object sender, EventArgs e)
    {
        MyPetShopEntities db = new MyPetShopEntities();
        var results = db.Table.GroupBy(p => p.CategoryId).Select(g => new
        {
            Key = g.Key,
            Count = g.Count(),
            MaxPrice = g.Max(p => p.ListPrice)
        });
        gvCategory.DataSource = results.ToList();
        gvCategory.DataBind();
    
    }

使产品名为****的手机价格进行降序排列

protected void btnOrder_Click(object sender, EventArgs e)
    {
        MyPetShopEntities db = new MyPetShopEntities();
        
        var results = db.Table.OrderByDescending(p => p.UnitCost);
        gvCategory.DataSource = results.ToList();
        gvCategory.DataBind();
    }