ASP.NET LINQ _2

  ASPNETDBDataContext aspnetdb = new ASPNETDBDataContext(); // 反回需要显示的列 //var linq_sql = from clo in aspnetdb.Orders // select clo.ShipName; //反回在匿名类中将City和Country合并在Address显示 //var linq_sql = from clo in aspnetdb.Customers // select new // {Address=clo.City+":"+clo.Country, // CompanyName=clo.CompanyName}; //反回唯一 //var linq_sql = (from clo in aspnetdb.Customers // select clo).Distinct(); //反回总共的记录数 //var linq_sql = aspnetdb.Customers.Count(); //Response.Write(linq_sql.ToString()); //反回UnitPrice的价格总和，方式两种 //var linq_sql = aspnetdb.Products.Select(p=>p.UnitPrice).Sum();----简单形势 //var linq_sql = aspnetdb.Products.Sum(p=>p.UnitPrice);----映射形势 //Response.Write(linq_sql.ToString()); //反回所有记录中UnitPrice最小值 //var linq_sql = aspnetdb.Products.Select(p => p.UnitPrice).Min();---简单形势 //var linq_sql = aspnetdb.Products.Min(p=>p.UnitPrice);----映射形势 //var linq_sql = from p in aspnetdb.Products----获取每个种类最小值 // group p by p.CategoryID into g // select new // { // CategoryID = g.Key, // CheapestProducts = // g.Min(p=>p.UnitPrice) // }; this.GridView1.DataSource = linq_sql; this.GridView1.DataBind();