C#DataTable转list帮助类

新酱
136
文章
39
评论
更多
 2019年5月21日20:26:54 2 3,431 32字阅读0分6秒
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
        /// <summary>
        /// 将datatable转换成list
        /// </summary>
        /// <typeparam name="T">泛型填实体类</typeparam>
        /// <param name="dt">datatable的结果</param>
        /// <returns></returns>
        public 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 + "]转换出错," + ex.Message);
                        }
                    }
                }
                list.Add(s);
            }
            return list;
        }
  • 版权声明： 发表于 2019年5月21日20:26:54
  • 转载注明：https://www.xiaorenjc.net/program/asp-net/79

您必须才能发表评论！

评论：2   其中：访客  1   博主  1
    • 阿成 阿成 1
      2019年8月11日 上午11:48  沙发

      很好，很有帮助，顶一个