JSON字符串轉換ToDataTable

简易JSON字符串转换

/// <summary>
/// Json 字符串 To DataTable数据集合
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
public static DataTable JSONToDataTable(string json)
{
    DataTable dtResult = new DataTable();
    try
    {
        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 dtResult;
                }
                //Columns
                if (dtResult.Columns.Count == 0)
                {
                    foreach (string current in dictionary.Keys)
                    {
                        dtResult.Columns.Add(current, dictionary[current].GetType());
                    }
                }
                //Rows
                DataRow dataRow = dtResult.NewRow();
                foreach (string current in dictionary.Keys)
                {
                    dataRow[current] = dictionary[current];
                }
                dtResult.Rows.Add(dataRow);
            }
        }
    }
    catch (Exception e)
    {
        throw e;
    }
    return dtResult;
}