/// <summary>
/// datatable转list集合
/// </summary>
/// <typeparam name="T">list</typeparam>
/// <param name="table"></param>
/// <returns></returns>
public static List<T> ConvertDataTableToList<T>(DataTable table) where T : class, new()
{
List<T> list = new List<T>();
foreach (DataRow row in table.Rows)
{
T obj = new T();
foreach (PropertyInfo info in obj.GetType().GetProperties())
{
if (table.Columns.Contains(info.Name))
{
if (row[info.Name] != DBNull.Value)
{
info.SetValue(obj, row[info.Name], null);
}
}
}
list.Add(obj);
}
return list;
}
调用例子:
List<KHDADZModel> list = ConvertDataTableToList<KHDADZModel>(dt);