利用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 }
View Code

 

 

输出样例：

[
    {
        "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
    }
]

　　

posted @ 2021-02-05 10:40  看代码`lookdaima.com  阅读(198)  评论(0)    收藏  举报