利用Newtonsoft.Json的JsonConvert.SerializeObject将DataTable转成Json输出
原文链接：
http://www.lookdaima.com/page/docItemDetail.html?id=2eadea02-4f10-41c6-a74a-682856972363
关键代码：
1 protected void GoDemo() 2 { 3 // 序列化DataTable // 4 DataTable dt = new DataTable(); 5 dt.Columns.Add("Age", Type.GetType("System.Int32")); 6 dt.Columns.Add("Name", Type.GetType("System.String")); 7 dt.Columns.Add("Sex", Type.GetType("System.String")); 8 dt.Columns.Add("IsMarry", Type.GetType("System.Boolean")); 9 10 for (int i = 0; i < 4; ++i) 11 { 12 DataRow dr = dt.NewRow(); 13 dr["Age"] = i + 1; 14 dr["Name"] = "Name" + i; 15 dr["Sex"] = i % 2 == 0 ? "男" : "女"; 16 dr["IsMarry"] = i % 2 > 0 ? true : false; 17 dt.Rows.Add(dr); 18 } 19 20 txt_Result.Text = JsonConvert.SerializeObject(dt); 21 }
输出样例：
[
{
"Age":1,
"Name":"Name0",
"Sex":"男",
"IsMarry":false
},
{
"Age":2,
"Name":"Name1",
"Sex":"女",
"IsMarry":true
},
{
"Age":3,
"Name":"Name2",
"Sex":"男",
"IsMarry":false
},
{
"Age":4,
"Name":"Name3",
"Sex":"女",
"IsMarry":true
}
]
