[转]Linq查询DataTable,DataRow

 原文:http://www.cnblogs.com/wucg/archive/2010/10/13/1850053.html

static void Main()
        {
            string strcon = global::TestLinqToSQL.Properties.Settings.Default.testConnectionString;
            SqlConnection conn = new SqlConnection(strcon);
            SqlDataAdapter da = new SqlDataAdapter("select * from T_Teacher", strcon);
            DataTable dt = new DataTable();
            da.Fill(dt);
            conn.Close();
  
            IEnumerable<DataRow> q1 = from r in dt.AsEnumerable()
                                      where r.Field<int>("ID") % 2 == 0
                                      select r;
            foreach (var item in q1)
            {
                Console.WriteLine("ID={0},Name={1},Birthday={2}", item["ID"].ToString(), item["Name"].ToString(), item["Birthday"].ToString());
            }
            Console.WriteLine("-----------------------------------");
            IEnumerable<DataRow> q2 = from r in dt.AsEnumerable()
                                      where r.Field<int>("ID")>10
                                      select r;
            foreach (var item in q2)
            {
                Console.WriteLine("ID={0},Name={1},Birthday={2}", item["ID"].ToString(), item["Name"].ToString(), item["Birthday"].ToString());
            }
            Console.WriteLine("-----------------------------------");
            DataTable dt1 = q1.CopyToDataTable();
            DataTable dt2 = q2.CopyToDataTable();
//集合排除
            //var except = dt2.AsEnumerable().Except(dt1.AsEnumerable() , DataRowComparer.Default);
//集合并
            //var except = dt2.AsEnumerable().Union(dt1.AsEnumerable(), DataRowComparer.Default); 
//集合交
            var except = dt2.AsEnumerable().Intersect(dt1.AsEnumerable(), DataRowComparer.Default);
            foreach (var item in except)
            {
                Console.WriteLine("ID={0},Name={1},Birthday={2}", item["ID"].ToString(), item["Name"].ToString(), item["Birthday"].ToString());
            }
            Console.WriteLine("done");
            Console.ReadLine();
        }

 


posted @ 2013-01-20 22:11  great wang  阅读(796)  评论(0编辑  收藏  举报