DataTable转List

来源:互联网 发布:影视后期特效合成软件 编辑:程序博客网 时间:2024/06/05 02:57

将DataTable转划成List的方法


public static List<Dictionary<string, object>> DataTableToList(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().Trim());                }                list.Add(result);            }            return list;        }


0 0