C#中DataTable和List互转

港控/mmm° 2024-03-24 17:07 126阅读 0赞

#### 文章目录 ####

*  C\#中DataTable和List互转
 *   *  1. DataTable转List
     *  2. List转DataTable
     *  3. 使用

## C\#中DataTable和List互转 ##

### 1. DataTable转List ###

public class DtToList<T> where T : new()  
    {
        
         /// <summary>
         /// datatable to list
         /// </summary>
         /// <param name="dt"></param>
         /// <returns></returns>
         public static  List<T> ConvertToModel(DataTable dt)
         {
        
    
             List<T> ts = new List<T>();// 定义集合
             Type type = typeof(T); // 获得此模型的类型
             string tempName = "";
             foreach (DataRow dr in dt.Rows)
             {
        
                 T t = new T();
                 PropertyInfo[] propertys = t.GetType().GetProperties();// 获得此模型的公共属性
                 foreach (PropertyInfo pi in propertys)
                 {
        
                     tempName = pi.Name;
                     if (dt.Columns.Contains(tempName))
                     {
        
                         if (!pi.CanWrite) continue;
                         object value = dr[tempName];
                         if (value != DBNull.Value)
                            pi.SetValue(t, value, null);
                     }
                 }
                 ts.Add(t);
             }
             return ts;
         }
    }

### 2. List转DataTable ###

/// <summary>
     /// list to datatable
     /// </summary>
     /// <typeparam name="T"></typeparam>
     /// <param name="collection"></param>
     /// <returns></returns>
     public  DataTable  ListToDt<T>(IEnumerable<T> collection)
     {
        
         var props = typeof(T).GetProperties();
         var dt = new DataTable();
         dt.Columns.AddRange(props.Select(p => new 
         DataColumn(p.Name, p.PropertyType)).ToArray());
         if (collection.Count() > 0)
         {
        
             for (int i = 0; i < collection.Count(); i++)
             {
        
                 ArrayList tempList = new ArrayList();
                 foreach (PropertyInfo pi in props)
                 {
        
                     object obj = pi.GetValue(collection.ElementAt(i), null);
                     tempList.Add(obj);
                 }
                 object[] array = tempList.ToArray();
                 dt.LoadDataRow(array, true);
              }
          }
          return dt;
     }

### 3. 使用 ###

// 创建一个测试用的集合，GetCustomerContact()为一个返回List的测试的方法
    List<CustomerContact> list =  GetCustomerContact();
    
    // 1. List 转 DataTable
    DataTable dt = ListToDt<CustomerContact>(list);
    foreach (DataRow mDr in dt.Rows)
    {
        
        foreach (DataColumn mDc in dt.Columns)
        {
        
            //MessageBox.Show(mDr[mDc].ToString());
        }
    }
    
    // 2. DataTable 转 List
    List<CustomerContact> list2 = DtToList<CustomerContact>.ConvertToModel(dt);