Linq——Count、Sum、Min、Max、Average
来源:互联网 发布:淘宝开店还能赚钱吗 编辑:程序博客网 时间:2024/05/18 01:15
/* from: http://blog.sina.com.cn/s/blog_412ec72c0100mall.html */
using System;using System.Data;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Text;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Collections.Generic;using System.Collections;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { #region 用Count()得出查询结果的个数 Response.Write("<hr>用Count()得出查询结果的个数<br>"); var langCount = (from s in GetStudents() select s.Language) .Distinct() .Count(); Response.Write(string.Format("<div class='result'>{0}</div>", langCount)); #endregion #region 用Count()的Lambda表达式满足条件的元素个数 Response.Write("<hr>用Count()得出查询结果的个数<br>"); var ageCoun = (from s in GetStudents() select s.Age) .Count(a=>a>22); Response.Write(string.Format("<div class='result'>{0}</div>", ageCoun)); #endregion #region 用Sum()将查询结果相加 Response.Write("<hr>用Sum()将查询结果相加<br>"); var ageSum = (from s in GetStudents() select s.Age) .Sum(); //var ageSum = GetStudents().Sum(s=>s.Age); Response.Write(string.Format("<div class='result'>{0}</div>", ageSum)); #endregion #region 用Min()得出查询结果的最小值 Response.Write("<hr>用Min()得出查询结果的最小值<br>"); var ageMin = (from s in GetStudents() select s.Age) .Min(); //var ageMin = GetStudents().Min(s => s.Age); Response.Write(string.Format("<div class='result'>{0}</div>", ageMin)); #endregion #region 用Max()得出查询结果的最大值 Response.Write("<hr>用Max()得出查询结果的最大值<br>"); var ageMax = (from s in GetStudents() select s.Age) .Max(); //var ageMax = GetStudents().Max(s => s.Age); Response.Write(string.Format("<div class='result'>{0}</div>", ageMax)); #endregion #region 用Average()得出查询结果的平均值 Response.Write("<hr>用Average()得出查询结果的平均值<br>"); var ageAverage = (from s in GetStudents() select s.Age) .Average(); //var ageAverage = GetStudents().Average(s => s.Age); Response.Write(string.Format("<div class='result'>{0}</div>", ageAverage)); #endregion } #region 构造一个学生集合体 private List<Student> GetStudents() { List<Student> students = new List<Student> { new Student{ Name="YOUNG", Age=25, Language="Chinese"}, new Student{ Name="JESSIE", Age=21, Language="Scotland"}, new Student{ Name="KELLY", Age=18, Language="English"}, new Student{ Name="JUNE", Age=20, Language="English"}, new Student{ Name="ADRIAN", Age=22, Language="Italy"}, new Student{ Name="BRUCE", Age=17, Language="Scotland"}, new Student{ Name="BRANT", Age=30, Language="Germany"}, new Student{ Name="BEN", Age=25, Language="Chinese"} }; return students; } #endregion}#region 学生类class Student{ public int Age { get; set; } public string Name { get; set; } public string Language { get; set; }}#endregion
- Linq——Count、Sum、Min、Max、Average
- Linq——Count、Sum、Min、Max、Average
- Linq——Count、Sum、Min、Max、Average
- Linq学习笔记(1.8)——Count、Sum、Min、Max、Average
- LINQ体验——LINQ语句之Select/Distinct和Count/Sum/Min/Max/Avg
- [转]LINQ体验(5)——LINQ语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- LINQ体验(5)——LINQ to SQL语句之Select/Distinct和Count/Sum/Min/Max/Avg
- linq to sql 用法 ----- count/sum/min/max/avg
- LINQ to SQL Count/Sum/Min/Max/Avg Join
- 7.8 Mathematical 算术和聚合操作 - Average/Concat/Count/Max/Min/Sum/Reduce
- 石子合并(动态规划)详细解题报告
- struts2的actionspring代理
- C语言学习之内存管理函数malloc()和free()
- GDI+测算文字绘制范围
- webwork与spring集成的三种方法
- Linq——Count、Sum、Min、Max、Average
- java序列化反序列化学习
- 关于编程,大学没有传授的10件事
- Linux下查看CPU信息[/proc/cpuinfo]
- STM32 启动代码 startup.c main函数之前解析
- Delphi 单元文件结构
- jQuery设计思想
- delphi 工程文件结构
- javaScript中利用ActiveXObject来创建FileSystemObject操作文件