首页 > 代码库 > 将集合类转换成DataTable

将集合类转换成DataTable

 /// <summary>        

/// 将集合类转换成DataTale        

/// </summary>        

/// <param name="list">集合</param>        

/// <returns></returns>        

public static DataTable ToDataTable(IList list)         {            

DataTable result = new DataTable();            

if (list == null)            

{                

return result;            

}

 if (list.Count > 0)            

{                

PropertyInfo[] propertys = list[0].GetType().GetProperties();                

foreach (PropertyInfo pi in propertys)                

{                    

result.Columns.Add(pi.Name, pi.PropertyType);                

}

 for (int i = 0; i < list.Count; i++)                

{                    

ArrayList tempList = new ArrayList();                    

foreach (PropertyInfo pi in propertys)                    

{                        

object obj = pi.GetValue(list[i], null);                        

tempList.Add(obj);                    

}                    

object[] array = tempList.ToArray();                    

result.LoadDataRow(array, true);                

}            

}            

return result;        

}

将集合类转换成DataTable