首页 > 代码库 > DataTable 转换为List

DataTable 转换为List

 protected void Button1_Click(object sender, EventArgs e)
        {
            //    string postfix = string.Empty;
            //    string fileType = string.Empty;
            //    postfix = ef[4, 1];
            //    fileType = ef[4, 2];
            ////string [,]aa =new string[,]{{"aa","BB","CC","dd"}};
            DataTable dt = new DataTable();
            dt.Columns.Add("ID", typeof(int));
            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("Sex", typeof(string));
            dt.Columns.Add("Age", typeof(int));
            dt.Columns["ID"].AutoIncrement = true;

            for (int i = 0; i < 10; i++)
            {
                DataRow dr = dt.NewRow();
                dr["Name"] = "Martin" + i;
                dr["Sex"] = "男";
                dr["Age"] = i;
                dt.Rows.Add(dr);
            }
            List<PeopleEntity> list = ConvertHelper<PeopleEntity>.ConvertToList(dt);

        }

 

 class ConvertHelper<T> where T : new()
    {
        /// <summary>
        /// 利用反射和泛型
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static List<T> ConvertToList(DataTable dt)
        {
            // 定义集合
            List<T> ts = new List<T>();
            // 获得此模型的类型
            Type type = typeof(T);
            //定义一个临时变量
            string tempName = string.Empty;
            //遍历DataTable中所有的数据行
            foreach (DataRow dr in dt.Rows)
            {
                T t = new T();
                // 获得此模型的公共属性
                PropertyInfo[] propertys = t.GetType().GetProperties();
                //遍历该对象的所有属性
                foreach (PropertyInfo pi in propertys)
                {
                    tempName = pi.Name;//将属性名称赋值给临时变量
                    //检查DataTable是否包含此列(列名==对象的属性名) 
                    if (dt.Columns.Contains(tempName))
                    {
                        // 判断此属性是否有Setter
                        if (!pi.CanWrite) continue;//该属性不可写,直接跳出
                        //取值
                        object value = http://www.mamicode.com/dr[tempName];
                        //如果非空,则赋给对象的属性
                        if (value != DBNull.Value)
                            pi.SetValue(t, value, null);
                    }
                }
                //对象添加到泛型集合中
                ts.Add(t);
            }

            return ts;

        }

    }