DataTable转成List

最新推荐文章于 2023-09-19 14:58:22 发布

白葛

最新推荐文章于 2023-09-19 14:58:22 发布

阅读量2.5k

点赞数 3

CC 4.0 BY-SA版权

分类专栏： c# 文章标签： c# asp.net

本文链接：https://blog.youkuaiyun.com/xiongliuyun/article/details/125865088

c# 专栏收录该内容

11 篇文章

订阅专栏

DataTable转成List

    /// <summary>
    /// DataTable转成List
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="dt"></param>
    /// <returns></returns>
    public static List<T> ToDataList<T>(DataTable dt)
    {
        var list = new List<T>();
        var plist = new List<PropertyInfo>(typeof(T).GetProperties());
        foreach (DataRow item in dt.Rows)
        {
            T s = Activator.CreateInstance<T>();
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                PropertyInfo info = plist.Find(p => p.Name == dt.Columns[i].ColumnName);
                if (info != null)
                {
                    try
                    {
                        if (!Convert.IsDBNull(item[i]))
                        {
                            object v = null;
                            if (info.PropertyType.ToString().Contains("System.Nullable"))
                            {
                                v = Convert.ChangeType(item[i], Nullable.GetUnderlyingType(info.PropertyType));
                            }
                            else
                            {
                                v = Convert.ChangeType(item[i], info.PropertyType);
                            }
                            info.SetValue(s, v, null);
                        }
                    }
                    catch (Exception ex)
                    {
                        throw new Exception("字段[" + info.Name + "]转换出错,value:" + item[i] + ex.ToString());
                    }
                }
            }
            list.Add(s);
        }
        return list;
    }