JSON转换DataTable代码,C#代码库,德仔网

代码语言

代码分类

【C#】 JSON转换DataTable

作者:擎苍 / 发布于2017/2/4/ 663

JSON转换DataTable

/// <summary>  
/// Json 字符串 转换为 DataTable数据集合  
/// </summary>  
/// <param name="json"></param>  
/// <returns></returns>  
public static DataTable ToDataTable(string json)  
{  
    DataTable dataTable = new DataTable();  //实例化  
    DataTable result;  
    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)  
                {  
                    result = dataTable;  
                    return result;  
                }  
                if (dataTable.Columns.Count == 0)  
                {  
                    foreach (string current in dictionary.Keys)  
                    {  
                        dataTable.Columns.Add(current, dictionary[current].GetType());  
                    }  
                }  
                DataRow dataRow = dataTable.NewRow();  
                foreach (string current in dictionary.Keys)  
                {  
                    dataRow[current] = dictionary[current];  
                }  
  
                dataTable.Rows.Add(dataRow); //循环添加行到DataTable中  
            }  
        }  
    }  
    catch  
    {  
    }  
    result = dataTable;  
    return result;  
}

试试其它关键字

同语言下

可能有用的

擎苍贡献的其它代码(12)