利用Newtonsoft.Json的JsonConvert.SerializeObject将DataTable转成Json输出

原文链接：
http://www.lookdaima.com/page/docItemDetail.html?id=2eadea02-4f10-41c6-a74a-682856972363

关键代码：

protected void GoDemo()
{
    // 序列化DataTable //
    DataTable dt = new DataTable();
    dt.Columns.Add("Age", Type.GetType("System.Int32"));
    dt.Columns.Add("Name", Type.GetType("System.String"));
    dt.Columns.Add("Sex", Type.GetType("System.String"));
    dt.Columns.Add("IsMarry", Type.GetType("System.Boolean"));

    for (int i = 0; i < 4; ++i)
    {
        DataRow dr = dt.NewRow();
        dr["Age"] = i + 1;
        dr["Name"] = "Name" + i;
        dr["Sex"] = i % 2 == 0 ? "男" : "女";
        dr["IsMarry"] = i % 2 > 0 ? true : false;
        dt.Rows.Add(dr);
    }

    txt_Result.Text = JsonConvert.SerializeObject(dt);
}

输出样例：
 

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