Json转换成DataTable

 　　今天看到Json转DataTable的例子，总结一下。。。。

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Web;
using System.Web.Script.Serialization;
namespace Json转DT_List
{

    class Program
    {
        static void Main(string[] args)
        {
            StreamReader sr = new StreamReader(@"F:\vs2015Test\VS2015学习\Json转DT，List\json1.json", Encoding.Default);
            var jsonStr = sr.ReadToEnd();
            var Dt = JsonToDatatable("");
            var str = DataTableToJson(new DataTable());
            Console.WriteLine(str);

            Console.ReadKey();
        }

        public static DataTable JsonToDatatable(string json)
        {
            DataTable datatable = null;
            if (!string.IsNullOrEmpty(json))
            {
                JavaScriptSerializer jss = new JavaScriptSerializer();
                ArrayList list = jss.Deserialize<ArrayList>(json);//将指定的 JSON 字符串转换为 T 类型的对象，可以是自己的List对象
                datatable = new DataTable();
                if (list.Count > 0)
                {
                    foreach (Dictionary<string, object> ll in list)//定义一个.Dictionary盛放list中的对象
                    {
                        if (datatable.Columns.Count == 0)
                        {
                            foreach (var key in ll.Keys)
                                datatable.Columns.Add(key, ll[key].GetType());   //添加新列                              
                        }
                        var newRow = datatable.NewRow();
                        foreach (var k in ll.Keys)
                        {
                            newRow[k] = ll[k];//给行上的列赋值
                        }
                        datatable.Rows.Add(newRow);
                    }
                }
            }
            return datatable;
        }

        public static string DataTableToJson(DataTable dt)
        {
            var jsonStr = "";
            if (dt != null)
            {
                ArrayList arrlist = new ArrayList();
                JavaScriptSerializer jss = new JavaScriptSerializer();
                foreach (DataRow row in dt.Rows)//遍历DataTable的Rows要是用DataRow
                {
                    Dictionary<string, object> dicDrow = new Dictionary<string, object>();
                    foreach (DataColumn c in dt.Columns)//遍历DataTable的Columns要使用DataColumn
                        dicDrow.Add(c.ColumnName, row[c.ColumnName]);
                    arrlist.Add(dicDrow);
                }
                jsonStr = jss.Serialize(arrlist);
            }
            return jsonStr;
        }
    }
}

 

 

该方法只能转换JSON数组格式的字符串，JSON对象格式只能转换成对象。。。。。

附带json1.json格式

[
  {
    "CFTUin": "769839263",
    "CancelDeadline": "2013-09-12 23:00:00",
    "CheckInDate": "2013-09-12 00:00:00",
    "CheckOutDate": "2013-09-13 00:00:00",
    "CityID": "0101",
    "CurrencyCode": "RMB",
    "HotelID": "00301105",
    "HotelName": "乐家连锁（北京天坛南门店）（原速8酒店（北京天坛南门店）",
    "ListID": "1000000005201308280002999652",
    "PayAmt": "228",
    "PayType": "0",
    "RommsCnt": "1",
    "SPTransID": "65202157",
    "State": "4"
  },
  {
    "CFTUin": "248486133",
    "CancelDeadline": "2013-10-13 23:00:00",
    "CheckInDate": "2013-10-13 00:00:00",
    "CheckOutDate": "2013-10-18 00:00:00",
    "CityID": "0201",
    "CurrencyCode": "RMB",
    "HotelID": "10201314",
    "HotelName": "上海凯顿酒店",
    "ListID": "1000000005201308280002999413",
    "PayAmt": "1140",
    "PayType": "0",
    "RommsCnt": "1",
    "SPTransID": "65197226",
    "State": "4"
  }
]