C# DataTable转List

ORM:

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Web;

namespace WebApplication1.date
{
    public class ORM
    {
        static public List<T> Tolist<T>(DataTable dt) where T : class, new()
        {
            Type t = typeof(T);
            PropertyInfo[] PropertyInfo = t.GetProperties();
            List<T> list = new List<T>();

            string typeName = string.Empty;
            foreach (DataRow item in dt.Rows)
            {
                T obj = new T();
                foreach (PropertyInfo s in PropertyInfo)
                {
                    typeName = s.Name;
                    if (dt.Columns.Contains(typeName))
                    {
                        if (!s.CanWrite) continue;

                        object value = item[typeName];
                        if (value == DBNull.Value) continue;

                        if (s.PropertyType == typeof(string))
                        {
                            s.SetValue(obj, value.ToString(), null);
                        }
                        else
                        {
                            s.SetValue(obj, value, null);
                        }
                    }
                }
                list.Add(obj);
            }
            return list;
        }

    }
}

创建DataTable:

DataTable tblDatas = new DataTable("User");
            DataColumn dc = null;
            dc = tblDatas.Columns.Add("Id", Type.GetType("System.Int32"));
            dc.AutoIncrement = true;//自动增加
            dc.AutoIncrementSeed = 1;//起始为1
            dc.AutoIncrementStep = 1;//步长为1
            dc.AllowDBNull = false;//

            dc = tblDatas.Columns.Add("Name", Type.GetType("System.String"));
            dc = tblDatas.Columns.Add("Pwd", Type.GetType("System.String"));

            DataRow newRow;
            newRow = tblDatas.NewRow();
            newRow["Name"] = "张三";
            newRow["Pwd"] = "123";
            tblDatas.Rows.Add(newRow);

            newRow = tblDatas.NewRow();
            newRow["Name"] = "李四";
            newRow["Pwd"] = "123456";
            tblDatas.Rows.Add(newRow);
            //调用ORM TOlist 泛型
            var i = ORM.Tolist<User>(tblDatas);
            var a = JsonConvert.SerializeObject(i);
            Console.WriteLine(a);
            Console.ReadKey();

创建类 User

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace ConsoleApp1
{
    public class User
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public string Pwd { get; set; }
    }
}