asp.net DataTable和Dataset序列化成Json格式

DataTableToJson：

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Text; 
using System.Runtime.Serialization.Json; 
using System.Runtime.Serialization; 
using System.IO; 
using System.Web.Script.Serialization; 
using MicroBlog.Common.APIHelper; 
using System.Web; 
 
namespace MicroBlog.Common.APIHelper 
{ 
    public class Resolve 
    { 
        /// <summary> 
        /// JSON文本转对象,泛型方法 
        /// </summary> 
        /// <typeparam name="T">类型</typeparam> 
        /// <param name="jsonText">JSON文本</param> 
        /// <returns>指定类型的对象</returns> 
        public static T JSONToObject<T>(string jsonText, HttpContext context) 
        { 
            JavaScriptSerializer jss = new JavaScriptSerializer(); 
            try 
            { 
                return jss.Deserialize<T>(jsonText); 
            } 
            catch (Exception ex) 
            { 
                return default(T); 
            } 
        } 
 
        /// <summary> 
        /// 将JSON文本转换成数据行 
        /// </summary> 
        /// <param name="jsonText">JSON文本</param> 
        /// <returns>数据行的字典</returns> 
        public static Dictionary<string, object> DataRowFromJSON(string jsonText, HttpContext context) 
        { 
            return JSONToObject<Dictionary<string, object>>(jsonText, context); 
        } 
    } 
} 
调用的话：Dictionary<string, object> dt = Resolve.DataRowFromJSON(requestbuffer, context);

DatasetToJson：

public class DataSetConverter : JsonConverter 
{ 
    public override bool CanConvert(Type objectType) 
    { 
        return typeof(DataSet).IsAssignableFrom(objectType); 
    } 
 
    public override void WriteJson(JsonWriter writer, object value) 
    { 
        DataSet ds = (DataSet)value; 
        writer.WriteStartObject(); 
        foreach (DataTable dt in ds.Tables) 
        { 
            writer.WritePropertyName(dt.TableName); 
            writer.WriteStartArray(); 
            foreach (DataRow dr in dt.Rows) 
            { 
                writer.WriteStartObject(); 
                foreach (DataColumn dc in dt.Columns) 
                { 
                    writer.WritePropertyName(dc.ColumnName); 
                    writer.WriteValue(dr[dc].ToString()); 
                } 
                writer.WriteEndObject(); 
            } 
            writer.WriteEndArray(); 
        } 
        writer.WriteEndObject(); 
    } 
} 
调用的话：JavaScriptConvert.SerializeObject(GetTestDataSet(), new DataSetConverter());

DataTableToJson2：

public class DataTableConverter : JsonConverter 
    { 
        public override void WriteJson(JsonWriter writer, object value) 
        { 
            DataTable dt = (DataTable)value; 
 
            writer.WriteStartArray(); 
            foreach (DataRow dr in dt.Rows) 
            { 
                writer.WriteStartObject(); 
                foreach (DataColumn dc in dt.Columns) 
                { 
                    writer.WritePropertyName(dc.ColumnName); 
                    writer.WriteValue(dr[dc].ToString()); 
                } 
                writer.WriteEndObject(); 
            } 
            writer.WriteEndArray(); 
 
 
        } 
 
        public override bool CanConvert(Type objectType) 
        { 
            return typeof(DataTable).IsAssignableFrom(objectType); 
        } 
    } 
调用的话：JavaScriptConvert.SerializeObject(GetTestDataTable(), new DataTableConverter());

摘自 _亚