将List转换为DataTable

来源：互联网发布：旅游数据库概念模型编辑：程序博客网时间：2024/04/30 17:32
    下面是一段将List转换为DataTable的方法，经常用到，希望对读者有帮助。//将List转换为DataTable        private DataTable ToDataTable<T>(List<T> items)        {            var tb = new DataTable(typeof(T).Name);            PropertyInfo[] props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);            foreach (PropertyInfo prop in props)            {                Type t = GetCoreType(prop.PropertyType);                tb.Columns.Add(prop.Name, t);            }            foreach (T item in items)            {                var values = new object[props.Length];                for (int i = 0; i < props.Length; i++)                {                    values[i] = props[i].GetValue(item, null);                }                tb.Rows.Add(values);            }            return tb;        }        public static Type GetCoreType(Type t)        {            if (t != null && IsNullable(t))            {                if (!t.IsValueType)                {                    return t;                }                else                {                    return Nullable.GetUnderlyingType(t);                }            }            else            {                return t;            }        }        public static bool IsNullable(Type t)        {            return !t.IsValueType || (t.IsGenericType && t.GetGenericTypeDefinition() == typeof(Nullable<>));        }
1 0