使用Newtonsoft JsonConvert反序列化Json数据到DataTable

 //JsonStr为Json字符串

  JArray array = JsonConvert.DeserializeObject(JsonStr) as JArray;//反序列化为数组

 if (array.Count > )

             {

                 StringBuilder columns = new StringBuilder();

                 DataTable table = new DataTable();

                 JObject objColumns = array[] as JObject;

                 //构造表头

                 foreach (JToken jkon in objColumns.AsEnumerable<JToken>())

                 {

                     string name = ((JProperty)(jkon)).Name;

                     columns.Append(name + ",");

                     table.Columns.Add(name);

                 }

                 //向表中添加数据

                 for (int i = ; i < array.Count; i++)

                 {

                     DataRow row = table.NewRow();

                     JObject obj = array[i] as JObject;

                     foreach (JToken jkon in obj.AsEnumerable<JToken>())

                     {

                         string name = ((JProperty)(jkon)).Name;

                         string value = ((JProperty)(jkon)).Value.ToString();

                         row[name] = value;

                     }

                     table.Rows.Add(row);

                 }

           }