Json数据转换为DataTable

首先要熟悉Json的数据格式：

         比如包含两条记录的data表：表示为==data: [{sid:'TD411B-G54E49001',......},{......}] 

  /// <summary>
    /// 将获取的Json数据转换为DataTable
    /// </summary>
    /// <param name="strJson">Json字符串</param>
    /// <returns></returns>
     public static DataTable JsonToDataTable(string strJson)
     {
         //取出表名  
         var 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("]"));

         //获取数据  
         rg = new Regex(@"(?<={)[^}]+(?=})");
         MatchCollection mc = rg.Matches(strJson);
         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 = strName;
                 foreach (string str in strRows)
                 {
                     var dc = new DataColumn();
                     string[] strCell = str.Split(':');
                     dc.ColumnName = strCell[0];
                     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("\"", "");
             }
             tb.Rows.Add(dr);
             tb.AcceptChanges();
         }

         return tb;
     }