解析如下:
/// <summary>
/// 解析数据表中的数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static List<Dictionary<string,object>> GetDataTableInfor(DataTable dt)
{
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, object> result = new Dictionary<string, object>();
foreach (DataColumn dc in dt.Columns)
{
result.Add(dc.ColumnName,dr[dc].ToString());
}
list.Add(result);
}
return list;
}
网友评论