Json List<T> DataTable 数据相互转换

最新推荐文章于 2022-05-28 00:35:16 发布

原创最新推荐文章于 2022-05-28 00:35:16 发布 · 537 阅读

0 ·

CC 4.0 BY-SA版权

Web开发专栏收录该内容

21 篇文章

订阅专栏

本文详细介绍了如何将各种数据类型（如列表、对象、数据表）转换为JSON格式，以及如何从JSON字符串中解析出特定类型的对象，并提供了一个将数据表转换为JSON格式的方法。这些技巧对于数据交互、API开发和数据存储非常有用。

List<T>转Json

public 
static string 
Obj2Json<T>(T data)
{
    try
    {
        System.Runtime.Serialization.Json.DataContractJsonSerializer serializer =
new System.Runtime.Serialization.Json.DataContractJsonSerializer(data.GetType());
        using
(MemoryStream ms = new
MemoryStream())
        {
            serializer.WriteObject(ms, data);
            return
Encoding.UTF8.GetString(ms.ToArray());
        }
    }
    catch
    {
        return
null;
    }
}

Json转List<T>

public 
static Object Json2Obj(String json,Type t)
{
    try
    {
        System.Runtime.Serialization.Json.DataContractJsonSerializer serializer =
new System.Runtime.Serialization.Json.DataContractJsonSerializer(t);
        using
(MemoryStream ms = new
MemoryStream(Encoding.UTF8.GetBytes(json)))
        {
            
            return 
serializer.ReadObject(ms);
        }
    }
    catch
    {
        return
null;
    }
}

DataTable 转Json

public 
static string 
DataTable2Json(DataTable dt)
{
    if
(dt.Rows.Count == 0)
    {
        return
"";
    }
 
    StringBuilder jsonBuilder =
new StringBuilder();
    // jsonBuilder.Append("{");
    //jsonBuilder.Append(dt.TableName.ToString()); 
    jsonBuilder.Append("[");//转换成多个model的形式
    for
(int 
i = 0; i < dt.Rows.Count; i++)
    {
        jsonBuilder.Append("{");
        for
(int 
j = 0; j < dt.Columns.Count; j++)
        {
            jsonBuilder.Append("\"");
            jsonBuilder.Append(dt.Columns[j].ColumnName);
            jsonBuilder.Append("\":\"");
            jsonBuilder.Append(dt.Rows[i][j].ToString());
            jsonBuilder.Append("\",");
        }
        jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
        jsonBuilder.Append("},");
    }
    jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
    jsonBuilder.Append("]");
    //  jsonBuilder.Append("}");
    return
jsonBuilder.ToString();
}

单个对象转JSON

public 
static T Json2Obj<T>(string
json) 
{
    T obj = Activator.CreateInstance<T>();
    using
(System.IO.MemoryStream ms = new
System.IO.MemoryStream(System.Text.Encoding.UTF8.GetBytes(json)))
    {
        System.Runtime.Serialization.Json.DataContractJsonSerializer serializer =
new System.Runtime.Serialization.Json.DataContractJsonSerializer(obj.GetType());
        return
(T)serializer.ReadObject(ms);
    }
}