Linq學習筆記(1.4)——orderby、Reverse()

using System;<br />using System.Data;<br />using System.Configuration;<br />using System.Linq;<br />using System.Web;<br />using System.Web.Security;<br />using System.Web.UI;<br />using System.Text;<br />using System.Web.UI.WebControls;<br />using System.Web.UI.WebControls.WebParts;<br />using System.Web.UI.HtmlControls;<br />using System.Collections.Generic;<br />using System.Collections;</p><p>public partial class _Default : System.Web.UI.Page<br />{<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> //按條件選擇後根據指定對象的某個屬性排序選擇結果<br /> Response.Write("<hr>按條件選擇後根據指定對象的某個屬性排序選擇結果：<br>");<br /> List<Student> StudentList = GetStudents();<br /> var students1 = from student in StudentList<br /> where student.Age>20<br /> orderby student.Age descending //或ascending，預設為ascending<br /> select student;</p><p> foreach (var student in students1)<br /> {<br /> Response.Write(string.Format("<div class='result'>age:{0}; name:{1}</div>", student.Age, student.Name));<br /> }</p><p> //多個排序條件<br /> Response.Write("<hr>多個排序條件：<br>");<br /> var students2 = from student in StudentList<br /> orderby student.Language,student.Age descending<br /> select student;<br /> foreach (var student in students2)<br /> {<br /> Response.Write(string.Format("<div class='result'>age:{0}; name:{1}; Language:{2}</div>", student.Age, student.Name, student.Language));<br /> }</p><p> //通過Reverse()對查詢結果反向排序<br /> Response.Write("<hr>通過Reverse()對查詢結果反向排序：<br>");<br /> var students3 = (from student in StudentList<br /> orderby student.Age<br /> select student)<br /> .Reverse();<br /> foreach (var student in students3)<br /> {<br /> Response.Write(string.Format("<div class='result'>age:{0}; name:{1}</div>", student.Age, student.Name));<br /> }<br /> }</p><p> //構造一個學生集合體<br /> private List<Student> GetStudents()<br /> {<br /> List<Student> students = new List<Student> {<br /> new Student{ Name="YOUNG", Age=25, Language="Chinese"},<br /> new Student{ Name="JESSIE", Age=21, Language="Scotland"},<br /> new Student{ Name="KELLY", Age=18, Language="English"},<br /> new Student{ Name="JUNE", Age=20, Language="English"},<br /> new Student{ Name="ADRIAN", Age=22, Language="Italy"},<br /> new Student{ Name="BRUCE", Age=17, Language="Scotland"},<br /> new Student{ Name="BRANT", Age=30, Language="Germany"},<br /> new Student{ Name="BEN", Age=25, Language="Chinese"}<br /> };<br /> return students;<br /> }<br />}</p><p>//學生類<br />class Student<br />{<br /> public int Age { get; set; }<br /> public string Name { get; set; }<br /> public string Language { get; set; }<br />}

結果顯示:

 

 

轉自：http://www.cnblogs.com/young18/archive/2007/06/05/772543.html