C#中将DataTable数据转为实体对象

 一个简单的将DataTable中的一行数据转为相应的实体对象

前提是 实体对象的属性名与DataTable中的列名一样。

1. public class DataSet2Entity
2.     {
3.         public static T ConvertToEntity<T>(DataTable dt, DataRow row) where T : new()
4.         {
5.             System.Data.DataColumnCollection columns = dt.Columns;
6.             int iColumnCount = columns.Count;
7.             int i;
8.             int j;
9.             T t = new T();
10.             Type elementType;
11.             elementType = t.GetType();
12.             System.Reflection.PropertyInfo[] publicProperties = elementType.GetProperties();
13.             //if (!(publicProperties.Length > iColumnCount))
14.             //{
15.             for (i = 0; i < iColumnCount; i++)
16.             {
17.                 for (j = 0; j < publicProperties.Length; j++)
18.                 {
19.                     if (columns[i].ColumnName.ToLower() == publicProperties[j].Name.ToLower())
20.                     {
21.                         if (publicProperties[j].PropertyType == typeof(int))
22.                         {
23.                             int num = 0;
24.                             try
25.                             {
26.                                 num = Convert.ToInt32(row[i]);
27.                             }
28.                             catch
29.                             {
31.                             }
32.                             publicProperties[j].SetValue(t, num, null);
33.                         }
34.                         else
35.                             if (publicProperties[j].PropertyType == typeof(string) && row[i] == System.DBNull.Value)
36.                             {
37.                                 publicProperties[j].SetValue(t, "", null);
38.                             }
39.                             else
40.                             {
41.                                 object value = row[i] == System.DBNull.Value ? null : row[i];
42.                                 publicProperties[j].SetValue(t, value, null);
43.                             }
46.                     }
47.                 }
48.             }
49.             return t;
50.         }
52.     }