序列化DataTable

   首先需要给项目添加 System.Web.Extensions.dll

 

   引用命名空间 using System.Web.Script.Serialization;

  

 /// <summary>
        /// 序列化DataTable
        /// </summary>
        public static string Serialize(DataTable dt)
        {
            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);
        }