首页 > Web开发 > 详细

DataTable序列化及反序列化Json

时间:2019-11-16 12:13:18      阅读:83      评论:0      收藏:0      [点我收藏+]

添加Json解析引用

using Newtonsoft.Json;

实现方式一:普通转换

private void button1_Click(object sender, EventArgs e)
{
  //序列化Json
  string sql = "SELECT s.BusinessEntityID,s.Name FROM Sales.Store AS s";
  textBox1.Text = JsonConvert.SerializeObject(DbHelper.GetDataTable(sql));

  //反序列化Json
  DataTable dt = new DataTable();
  dt = JsonConvert.DeserializeObject<DataTable>(textBox1.Text);
  dataGridView1.DataSource = dt;
}

实现方式二:Task任务

private void button1_Click(object sender, EventArgs e)
{
  //序列化Json
  string sql = "SELECT s.BusinessEntityID,s.Name FROM Sales.Store AS s";
  Task<string> task = new Task<string>(() => JsonConvert.SerializeObject(DbHelper.GetDataTable(sql)));
  task.Start();
  task.Wait();   textBox1.Text
= task.Result;   //反序列化Json   DataTable dt = new DataTable();   string json = textBox1.Text;   Task<DataTable> dtTask = new Task<DataTable>(() => JsonConvert.DeserializeObject<DataTable>(json));   dtTask.Start();
  dtTask.Wait();
  dataGridView1.DataSource = dtTask.Result;
}

效果

技术分享图片

DataTable序列化及反序列化Json

原文:https://www.cnblogs.com/win32pro/p/11870956.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!