把List<T>转换为DataTable

下面这个学习，把List<T>转换为Datatable。

下面先创建一个对象T:

 

class Ay    {        private int _ID;        public int ID        {            get { return _ID; }            set { _ID = value; }        }        private string _Account;        public string Account        {            get { return _Account; }            set { _Account = value; }        }        private string _Email;        public string Email        {            get { return _Email; }            set { _Email = value; }        }        public Ay()        {        }        public Ay(int id,string account,string email)        {            this._ID = id;            this._Account = account;            this._Email = email;        }    }

Source Code

 

此时，你可以写一个C#扩展方法：

 

public static DataTable ToDataTable<T>(this List<T> items)        {            DataTable dataTable = new DataTable();                       PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);            foreach (PropertyInfo prop in Props)            {                                dataTable.Columns.Add(prop.Name);            }            foreach (T obj in items)            {                var values = new object[Props.Length];                for (int i = 0; i < Props.Length; i++)                {                    values[i] = Props[i].GetValue(obj, null);                }                dataTable.Rows.Add(values);            }            return dataTable;        }

Source Code

 

下面，我们在List<T>添加几笔记录，然后使用上面的扩展方法，把List<T> 转换为DataTable.
为了看到结果，再把DataTable打印至控制台上：

class Az    {        public void ConvertListToDataTableTextDemo()        {            List<Ay> ays = new List<Ay>()            {                new Ay() { ID=1,Account="A0001",Email="[e-mail]" },                new Ay() { ID=2,Account="A0002",Email="[e-mail]"},                new Ay() {ID=3,Account="A0003",Email="[e-mail]" }            };          DataTable dt =  ays.ToDataTable();            foreach (DataRow row in dt.Rows)            {                Console.WriteLine();                for (int x = 0; x < dt.Columns.Count; x++)                {                    Console.Write(row[x].ToString() + " ");                }            }            Console.WriteLine("\n\r");        }    }

Source Code

 

控制台输出的结果：