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

jopen 12年前發布 | 1K 次閱讀

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);
    }
}

}</pre>調用的話: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();
}

}</pre>調用的話:JavaScriptConvert.SerializeObject(GetTestDataTable(), new DataTableConverter());

 本文由用戶 jopen 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
 轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!