DataTable转Json Json转DataTable

最新推荐文章于 2025-07-12 15:08:26 发布

转载最新推荐文章于 2025-07-12 15:08:26 发布 · 5.5k 阅读

文章标签：

#json #asp.net

ASP.NET 同时被 2 个专栏收录

98 篇文章

订阅专栏

JavaScript

65 篇文章

订阅专栏

本文介绍了如何在C#中将DataTable转换为JSON，并从JSON转换回DataTable的过程，包括使用JavaScriptSerializer进行序列化和反序列化。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DataTable转Json Json转DataTable

/// <summary>
    /// DataTable转Json
    /// </summary>
    /// <param name="dtb"></param>
    /// <returns></returns>
    #region DataTable转Json
    private string Dtb2Json(DataTable dtb)
    {
        JavaScriptSerializer jss = new JavaScriptSerializer();
        ArrayList dic = new ArrayList();
        foreach (DataRow row in dtb.Rows)
        {
            Dictionary<string, object> drow = new Dictionary<string, object>();
            foreach (DataColumn col in dtb.Columns)
            {
                drow.Add(col.ColumnName, row[col.ColumnName]);
            }
            dic.Add(drow);
        }
        return jss.Serialize(dic);
    }
    #endregion

    /// <summary>
    /// Json转DataTable
    /// </summary>
    /// <param name="json"></param>
    /// <returns></returns>
    #region Json转DataTable
    private DataTable Json2Dtb(string json)
    {
        JavaScriptSerializer jss = new JavaScriptSerializer();
        ArrayList dic = jss.Deserialize<ArrayList>(json);
        DataTable dtb = new DataTable();
        if (dic.Count > 0)
        {
            foreach (Dictionary<string, object> drow in dic)
            {
                if (dtb.Columns.Count == 0)
                {
                    foreach (string key in drow.Keys)
                    {
                        dtb.Columns.Add(key, drow[key].GetType());
                    }
                } DataRow row = dtb.NewRow();
                foreach (string key in drow.Keys)
                { row[key] = drow[key]; }
                dtb.Rows.Add(row);
            }
        }
        return dtb;
    }