DataTable 转换为List 集合

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

/// <summary> /// DataTable转List<T> /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dt"></param> /// <returns></returns> public static List<T> toList<T>(this DataTable dt) where T: class, new() {     var prList = new List<PropertyInfo>();     var t = typeof(T);       Array.ForEach(t.GetProperties(), p =>     {         if(dt.Columns.IndexOf(p.Name) != -1)         {             prList.Add(p);         }     });       var ret = new List<T>();     foreach(DataRow dr in dt.Rows)     {         var item = new T();         prList.ForEach(p =>         {             if (dr[p.Name] != DBNull.Value)             {                 p.SetValue(item, dr[p.Name], null);             }         });           ret.Add(item);     }       return ret; }

　　以上为扩展函数，怎么调用相信你懂的！！