C# 中 Json 和 DataTable的转换方法
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
DataTable dt = null; dt = new DataTable();//实例化 JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大数值 ArrayList arrayList = javaScriptSerializer.Deserialize<ArrayList>(json); if (arrayList.Count > 0) { foreach (Dictionary<string, object> dictionary in arrayList) { if (dictionary.Keys.Count<string>() == 0) { return dt; } foreach (string current in dictionary.Keys) { if (dt.Columns.Contains(current)) { continue; } dt.Columns.Add(current, dictionary[current].GetType()); } DataRow dataRow = dt.NewRow(); foreach (string current in dictionary.Keys) { dataRow[current] = dictionary[current]; } dt.Rows.Add(dataRow); //循环添加行到DataTable中 } } return dt;