如何处理嵌套的json字符串转成datable再进行取值呢？

Question

  /// <summary>
    /// Json 字符串 转换为 DataTable数据集合
    /// </summary>
    /// <param name="json"></param>
    /// <returns></returns>
    public static DataTable DtToJson(string json)
    {
        ////取出表名  
        //Regex rg = new Regex(@"(?<={)[^:]+(?=:/[)", RegexOptions.IgnoreCase);
        //string strName = rg.Match(strJson).Value;
        DataTable tb = null;
        ////去除表名  
        //strJson = strJson.Substring(strJson.IndexOf("[") + 1);
        //strJson = strJson.Substring(0, strJson.IndexOf("]"));

        //获取数据  
        Regex rg = new Regex(@"(?<={)[^}]+(?=})");
        MatchCollection mc = rg.Matches(json);
        for (int i = 0; i < mc.Count; i++)
        {
            string strRow = mc[i].Value;
            string[] strRows = strRow.Split(',');

            //创建表  
            if (tb == null)
            {
                tb = new DataTable();
                tb.TableName = "";
                foreach (string str in strRows)
                {
                    DataColumn dc = new DataColumn();
                    string[] strCell = str.Split(':');

                    dc.ColumnName = strCell[0].ToString().Replace("\"", "").Trim();
                    tb.Columns.Add(dc);
                }
                tb.AcceptChanges();
            }

            //增加内容  
            DataRow dr = tb.NewRow();
            for (int r = 0; r < strRows.Length; r++)
            {
                dr[r] = strRows[r].Split(':')[1].Trim().Replace("，", ",").Replace("：", ":").Replace("/", "").Replace("\"", "").Trim();
            }
            tb.Rows.Add(dr);
            tb.AcceptChanges();
        }

        return tb;
    }

    

目标是我要将json字符串转化成datatable后，然后取到process_code的值？

 

 

Answer 1

$(document).ready(function() {
    $('#example').dataTable({
        "columnDefs": [{
            "render": function(data, type, row) {
                return data + ' (' + row[3] + ')';
            },
            "targets": 0
        }]
    });
});

使用列渲染