VB.net 2010 视频教程 VB.net 2010 视频教程 python基础视频教程
SQL Server 2008 视频教程 c#入门经典教程 Visual Basic从门到精通视频教程
当前位置:
首页 > c#编程 >
  • DataTable转成实体列表 和 DataRow转成实体类

复制代码
 1         #region DataTale转为实体列表  
 2         /// <summary>  
 3         /// DataTale转为实体列表  
 4         /// </summary>  
 5         /// <typeparam name="T">实体类类型</typeparam>  
 6         /// <param name="table">DataTable</param>  
 7         /// <returns>List<T></returns>  
 8         public List<T> DataTableToModelList<T>(DataTable table)
 9         {
10             List<T> list = new List<T>();
11             T t = default(T);
12             PropertyInfo[] propertypes = null;
13             string tempName = string.Empty;
14             foreach (DataRow row in table.Rows)
15             {
16                 t = Activator.CreateInstance<T>();
17                 propertypes = t.GetType().GetProperties();
18                 foreach (PropertyInfo pro in propertypes)
19                 {
20                     tempName = pro.Name;
21                     if (table.Columns.Contains(tempName))
22                     {
23                         object value = row[tempName];
24                         if (value.GetType() == typeof(System.DBNull))
25                         {
26                             value = null;
27                         }
28                         pro.SetValue(t, value, null);
29                     }
30                 }
31                 list.Add(t);
32             }
33             return list;
34         }
35         #endregion
36 
37         #region   DataRow转为实体类  
38         /// <summary>  
39         /// DataRow转为实体类  
40         /// </summary>  
41         /// <typeparam name="T">实体类类型</typeparam>  
42         /// <param name="row">DataRow</param>  
43         /// <returns>T</returns>  
44         public T DataRowToModel<T>(DataRow row)
45         {
46 
47             T t = default(T);
48             PropertyInfo[] propertypes = null;
49             string tempName = string.Empty;
50             t = Activator.CreateInstance<T>();
51             propertypes = t.GetType().GetProperties();
52             foreach (PropertyInfo pro in propertypes)
53             {
54                 tempName = pro.Name;
55                 if (row.Table.Columns.Contains(tempName))
56                 {
57                     object value = row[tempName];
58                     if (value.GetType() == typeof(System.DBNull))
59                     {
60                         value = null;
61                     }
62                     pro.SetValue(t, value, null);
63                 }
64             }
65             return t;
66         }
67         #endregion
复制代码

相关教程