/// <summary>
/// datable转listK<dictionary<string,object>>
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static List<Dictionary<string, object>> converToList(DataTable dt)
{
List<Dictionary<string, object>> listReturn = new List<Dictionary<string, object>>();
foreach (DataRow item in dt.Rows)
{
Dictionary<string, object> dict = new Dictionary<string, object>();
foreach (DataColumn Columns in dt.Columns)
{
dict.Add(Columns.ColumnName, item[Columns.ColumnName].ToString());
}
listReturn.Add(dict);
}
return listReturn;
}
#endregion