将datatable变成规范的json格式

public static string Serialize(DataTable dt, bool flag)
            {

                JavaScriptSerializer serializer = new JavaScriptSerializer();

                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 serializer.Serialize(list);

            }

 

 

需要有这三个引用

using Newtonsoft.Json;
using System.Runtime.Serialization;
using System.Web.Script.Serialization;

 

在前台将json变成list      也叫datatable的格式化

 msg1 = $.parseJSON(msg.d);