Mega Code Archive

 
Categories / ASP.Net Tutorial / ADO Net Database
 

Use Linq-to-Objects to query against NET collections using the LINQ syntax

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"      Inherits="Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title>Linq-to-Objects</title> </head> <body>     <div id="pageContent">         <form id="form2" runat="server">             <asp:Button ID="Button1" runat="server" Text="Click" onclick="Button1_Click" />         </form>     </div> </body> </html> File: Default.aspx.cs using System; using System.Data; using System.Configuration; using System.Collections; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Xml.Linq; public partial class Default : System.Web.UI.Page {     protected void Button1_Click(object sender, EventArgs e)     {         int[] fiboNumbers = new int[] { 0, 1, 1, 2, 3, 5, 8, 13, 21, 34 };         var data0 = from n in fiboNumbers                    where n % 2 == 0                    select n;         Response.Write(data0.Count());         Response.Write("<hr/>");         var data1 = (from n in fiboNumbers                     where n % 2 == 0 && n <10                     select n).Sum();         Response.Write(data1);     } }