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,"姓名":"张德","性别":"男","学历":"本科"}]

posted @ 2018-03-01 14:49  龍☆  阅读(189)  评论(0)    收藏  举报