C# DataTable 与 Json 互转

目录

 

一、添加JsonDataTable.CS文件

二、添加Form1窗体

三、测试效果图

---

 

一、添加JsonDataTable.CS文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Newtonsoft.Json;
using System.Data;
using System.Text.RegularExpressions;


namespace WinForms
{
    public static class JsonDataTable
    {
		/// <summary>
		///  将DataTable转换为Json
		/// </summary>
		/// <param name="dt"></param>
		/// <returns></returns>
		public static string DataTableToJson(DataTable dt)
		{
			string JsonString = string.Empty;
			if (dt.Rows.Count > 0)
			{
				return JsonString = JsonConvert.SerializeObject(dt);
			}
			return null;
		}

		/// <summary>
		/// 将Json转换为DataTable
		/// </summary>
		/// <param name="strJson">得到的json</param>
		/// <returns></returns>
		public static DataTable JsonToDataTable(string strJson)
		{
			//转换json格式
			strJson = strJson.Replace(",\"", "*\"").Replace("\":", "\"#").ToString();
			//取出表名
			var rg = new Regex(@"(?<={)[^:]+(?=:\[)", RegexOptions.IgnoreCase);
			string strName = rg.Match(strJson).Value;
			DataTable tb = null;
			//去除表名
			strJson = strJson.Substring(strJson.IndexOf("[") + 1);
			strJson = strJson.Substring(0, strJson.IndexOf("]"));

			//获取数据
			rg = new Regex(@"(?<={)[^}]+(?=})");
			MatchCollection mc = rg.Matches(strJson);
			for (int i = 0; i < mc.Count; i++)
			{
				string strRow = mc[i].Value;
				string[] strRows = strRow.Split('*');

				//创建表
				if (tb == null)
				{
					tb = new DataTable();
					tb.TableName = strName;
					foreach (string str in strRows)
					{
						var dc = new DataColumn();
						string[] strCell = str.Split('#');

						if (strCell[0].Substring(0, 1) == "\"")
						{
							int a = strCell[0].Length;
							dc.ColumnName = strCell[0].Substring(1, a - 2);
						}
						else
						{
							dc.ColumnName = strCell[0];
						}
						tb.Columns.Add(dc);
					}
					tb.AcceptChanges();
				}

				//增加内容
				DataRow dr = tb.NewRow();
				for (int r = 0; r < strRows.Length; r++)
				{
					dr[r] = strRows[r].Split('#')[1].Trim().Replace("，", ",").Replace("：", ":").Replace("\"", "");
				}
				tb.Rows.Add(dr);
				tb.AcceptChanges();
			}

			return tb;
		}
	}
}

二、添加Form1窗体

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Newtonsoft.Json;

namespace WinForms
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void btnJsonToTable_Click(object sender, EventArgs e)
        {
            string strJson = "{links:[{\"name\":\"BeJson\",\"url\":\"http://www.bejson.com\"},{\"name\":\"BeJson2\",\"url\":\"http://www.bejson2.com\"}]}";
            DataTable dt = JsonDataTable.JsonToDataTable(strJson);
            MessageBox.Show(dt.Rows.Count.ToString());
        }

        private void btnTableToJson_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("Name");
            dt.Columns.Add("URL");
            DataRow dr = dt.NewRow();
            dr[0] = "BeJson";
            dr[1] = "http://www.bejson.com";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr[0] = "BeJson2";
            dr[1] = "http://www.bejson.com2";
            dt.Rows.Add(dr);

            dt.TableName = "links";

            string strJson = JsonDataTable.DataTableToJson(dt);
            MessageBox.Show(strJson);
        }
    }
}

三、测试效果图