C# Json and DataTable 互转

等以后丶

已于 2024-07-04 17:05:42 修改

阅读量288

点赞数 1

文章标签： c#

于 2023-06-21 08:47:29 首次发布

本文链接：https://blog.csdn.net/qq_40287041/article/details/130339375

版权

这段代码展示了如何将DataTable对象转换成JSON字符串，以及如何将JSON字符串反序列化回DataTable。方法包括遍历DataTable的列和行，创建Dictionary对象，然后进行序列化和反序列化操作。异常处理确保了数据转换的稳定性。

摘要由CSDN通过智能技术生成

public string ToJson(DataTable dt)
        {
            List<Dictionary<string, object>> dic = new List<Dictionary<string, object>>();
            foreach (DataRow dr in dt.Rows)
            {
                Dictionary<string, object> drow = new Dictionary<string, object>();
                foreach (DataColumn dc in dt.Columns)
                {
                    drow.Add(dc.ColumnName.ToLower(), dr[dc.ColumnName]);
                }
                dic.Add(drow);
            }
            //序列化  
            return Utilities.Helper.JsonHelper.Serialize(dic);
        }
        public DataTable ToDataTable(string json)
        {
            DataTable dataTable = new DataTable(); //实例化
            DataTable result;
            try
            {
                List<Dictionary<string, object>> arrayList = Utilities.Helper.JsonHelper.Deserialize<List<Dictionary<string, object>>>(json);
                if (arrayList.Count > 0)
                {
                    foreach (Dictionary<string, object> dictionary in arrayList)
                    {
                        if (dictionary.Keys.Count<string>() == 0)
                        {
                            result = dataTable;
                            return result;
                        }
                        //Columns
                        if (dataTable.Columns.Count == 0)
                        {
                            foreach (string current in dictionary.Keys)
                            {
                                dataTable.Columns.Add(current, dictionary[current].GetType());
                            }
                        }
                        //Rows
                        DataRow dataRow = dataTable.NewRow();
                        foreach (string current in dictionary.Keys)
                        {
                            dataRow[current] = dictionary[current];
                        }
                        dataTable.Rows.Add(dataRow); //循环添加行到DataTable中
                    }
                }
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
            result = dataTable;
            return result;
        }