linqtodataset 实例.doc

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;namespace ConsoleApplication1 class LinqTest public static void Main() LinqToDataSet.Create_DataSet(); LinqToDataSet.PrintData(); class LinqToDataSet public static DataSet Create_DataSet() /在内存中创建数据源 string nameSet = 王霞, 张三, 李四, 李花, 王五, 陆六, 夏七, 吴八 ; string sexSet = 女, 男, 男, 女, 男, 男, 男, 男 ; int ageSet = 18, 20, 21, 22, 19, 20, 25, 24 ; DataSet ds = new DataSet(); DataTable dt = new DataTable(People); ds.Tables.Add(dt); dt.Columns.Add(new DataColumn(Name,Type.GetType(System.String); dt.Columns.Add(new DataColumn(Sex, Type.GetType(System.String); dt.Columns.Add(new DataColumn(Age, Type.GetType(System.Int32); for (int i = 0; i nameSet.Length; i+) DataRow dr = dt.NewRow(); drName = nameSeti; drSex = sexSeti; drAge = ageSeti; dt.Rows.Add(dr); return ds; public static void PrintData() /打印数据 DataSet ds = Create_DataSet(); DataTable dt = ds.TablesPeople; var query1=from item in dt.AsEnumerable() select item; foreach (var item in query1) Console.WriteLine(姓名:0，性别:1，年龄:2,item.Field(Name),item.Field(Sex),item.Field(Age); var query2 = from data in dt.AsEnumerable() select data.Field(Name); foreach (var item in query2) Console.WriteLine(姓名:0,item); var query3 = from data in dt.AsEnumerable() where data.Field(Age)=22 select data; foreach (var item in query3) Console.WriteLine(姓名:0，性别:1，年龄:2, item.Field(Name), item.Field(Sex), item.Field(Age); Console.ReadLine(); 修改表中字段数据LINQ to DataSet有时也需要对数据表中的数据进行修改，本节介绍如何使用SetField()修改数据。public static void UpdateData() DataSet ds = Create_DataSet(); DataTable dt = ds.TablesPeople; foreach (var item in dt.AsEnumerable() int age = item.Field(Age); item.SetField(Age, age + 2); foreach (var item in dt.AsEnumera