对象序列化成JSON

 

        /// <summary>
        /// DataTable序列化成json
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static string DataTableToJson(DataTable dt)
        {
            List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
            foreach (DataRow dr in dt.Rows)
            {
                Dictionary<string, string> temp = new Dictionary<string, string>();
                foreach (DataColumn dc in dt.Columns)
                {
                    temp.Add(dc.ColumnName, dr[dc].ToString());
                }
                list.Add(temp);
            }
            return new JavaScriptSerializer().Serialize(list);
        }