C # JSON list datatable Data Conversion

List <t> to JSON

?

12345678910111213141516

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 to list <t>

?

12345678910111213141516

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 to JSON

?

123456789101112131415161718192021222324252627282930

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("[");// Convert to multiple models    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();}

Convert a single object to JSON

 

?

123456789

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