DataTable 和 Json 互转

来源:csdn

发现有博友贴出的转换代码

public string DataTableToJson(System.Data.DataTable dt)  
     {  
         StringBuilder Json = new StringBuilder();  
         Json.Append("[");  
         if (dt.Rows.Count > 0)  
         {  
             for (int i = 0; i < dt.Rows.Count; i++)  
             {  
                 Json.Append("{");  
                 for (int j = 0; j < dt.Columns.Count; j++)  
                 {  
                     Json.Append("\\"" + dt.Columns[j].ColumnName.ToString() + "\\":\\"" + dt.Rows[i][j].ToString() + "\\"");  
                     if (j < dt.Columns.Count - 1)  
                     {  
                         Json.Append(",");  
                     }  
                 }  
                 Json.Append("}");  
                 if (i < dt.Rows.Count - 1)  
                 {  
                     Json.Append(",");  
                 }  
             }  
         }  
         //  Json.Append("]}");  
         Json.Append("]");  
         return Json.ToString();  
     }   


public DataTable JsonToDataTable(string strJson)  
        {  
            string strTableName = "Temp";  
            DataTable tb = null;  

            var rg = new Regex(@"(?<={)[^}]+(?=})");  
            MatchCollection mc = rg.Matches(strJson);  

            if(mc.Count==0)  
            {  
                return null;  
            }  
            string strRow = mc[0].Value;  
            string[] strRows = strRow.Split(',');  
            if (tb == null)  
            {  
                tb = new DataTable();  
                tb.TableName = strTableName;  
                foreach (string str in strRows)  
                {  
                    var dc = new DataColumn();  
                    string[] strCell = str.Split(':');  
                    dc.ColumnName = strCell[0].Replace("\\"", "");  
                    tb.Columns.Add(dc);  
                }  
                tb.AcceptChanges();  
            }  

            JsonArray arr = JsonConvert.Import(strJson) as JsonArray;  

            foreach (JsonObject obj in arr)  
            {  
                DataRow dr = tb.NewRow();  
                for (int j = 0; j < tb.Columns.Count; j++)  
                {  
                    dr[tb.Columns[j].ColumnName] = obj[tb.Columns[j].ColumnName];  
                }  
                tb.Rows.Add(dr);  
            }  

            tb.AcceptChanges();  

            return tb;  
        }

发现下面的更加方便实用

using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using System;
using System.Data;

namespace socketClient.Tool
{
    /// <summary>
    /// Json 工具 引用了 Newtonsoft.Json.dll
    /// </summary>
    public class JsonTool
    {
        /// <summary>
        /// DataTable 转换为 Json 格式的字符串
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static String DataTable2Json(DataTable dt)
        {
            String json = JsonConvert.SerializeObject(dt, new DataTableConverter());
            return json;
        }

        /// <summary>
        /// Json 格式字符串转换为 DataTable
        /// </summary>
        /// <param name="json"></param>
        /// <returns></returns>
        public static DataTable Json2DataTable(String json)
        {
            DataTable tb = (DataTable)JsonConvert.DeserializeObject(json, typeof(DataTable));

            return tb;
        }
    }
}

    ''' <summary>
    ''' Json 格式字符串转换为 DataTable
    ''' </summary>
    ''' <param name="json"></param>
    ''' <returns></returns>
    Public Shared Function Json2DataTable(ByVal json As String) As DataTable

        Return DirectCast(JsonConvert.DeserializeObject(analysis.json.JsonDecode(json, "data"), GetType(DataTable)), DataTable)
    End Function