data table to json
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 WindowsFormsApp1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { richTextBox1.Text = DataTableToJsonWithJsonNet(getData()); } private DataTable getData() { DataTable dt = new DataTable(); dt.Columns.Add("编号", typeof(Int32)); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("性别", typeof(string)); dt.Columns.Add("学历", typeof(string)); dt.Rows.Add(1, "王超", "男", "本科"); dt.Rows.Add(2, "周丽", "女", "专科"); dt.Rows.Add(3, "李娟", "女", "专科"); dt.Rows.Add(4, "杨明", "男", "硕士"); dt.Rows.Add(5, "张德", "男", "本科"); return dt; } public string DataTableToJsonWithJsonNet(DataTable table) { string JsonString = string.Empty; JsonString = JsonConvert.SerializeObject(table); return JsonString; }
结果集:
[{"编号":1,"姓名":"王超","性别":"男","学历":"本科"},{"编号":2,"姓名":"周丽","性别":"女","学历":"专科"},{"编号":3,"姓名":"李娟","性别":"女","学历":"专科"},{"编号":4,"姓名":"杨明","性别":"男","学历":"硕士"},{"编号":5,"姓名":"张德","性别":"男","学历":"本科"}]
好的程序员,他们删掉的代码,比留下来的还要多很多。