如何使用json.net将c#泛型列表转换为json？

Question

我正在将我的datatable转换为C#泛型列表。

 DataTable dt = mydata();
 List<DataRow> list = dt.AsEnumerable().ToList();

现在我该如何使用json.net将这个list转换为JSON？有什么建议吗？

JSON格式的示例应该像这样，

{"Table" : [{"userid" : "1","name" : "xavyTechnologies","designation" : "",
"phone" : "9999999999","email" : "[e-mail]","role" : "Admin","empId" : "",
 "reportingto" : ""},{"userid" : "2","name" : "chendurpandian","designation" :
 "softwaredeveloper","phone" : "9566643707","email" : "[e-mail]",
 "role" : "Super User","empId" : "1","reportingto" : "xavyTechnologies"},
{"userid" : "3","name" : "sabarinathan","designation" : "marketer","phone" :
"66666666666","email" : "[e-mail]","role" : "User",
 "empId" : "2","reportingto" : "chendurpandian"}]}

- ACP

Answer 1

这里有一个例子：

using System;
using System.Data;
using Newtonsoft.Json.Linq;

class Test
{
    static void Main()
    {
        DataTable table = new DataTable();
        table.Columns.Add("userid");
        table.Columns.Add("phone");
        table.Columns.Add("email");

        table.Rows.Add(new[] { "1", "9999999", "[e-mail]" });
        table.Rows.Add(new[] { "2", "1234567", "[e-mail]" });
        table.Rows.Add(new[] { "3", "7654321", "[e-mail]" });

        var query = from row in table.AsEnumerable()
                    select new {
                        userid = (string) row["userid"],
                        phone = (string) row["phone"],
                        email = (string) row["email"]            
                    };

        JObject o = JObject.FromObject(new
        {
            Table = query
        });

        Console.WriteLine(o);
    }
}

文档：使用Json.NET进行LINQ to JSON

- Jon Skeet

---

示例使用了 LINQ，但我想使用一个通用列表。 - ACP

@Pandiya：只需将 table.AsEnumerable() 更改为 list。考虑到你在示例中使用了 DataTable，我认为你想要一个 DataTable 作为你的原始数据来源......否则你为什么费劲写那部分代码呢？ - Jon Skeet

Answer 2

var oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string sJSON = oSerializer.Serialize(yourList);

参考: http://blogs.microsoft.co.il/blogs/pini_dayan/archive/2009/03/12/convert-objects-to-json-in-c-using-javascriptserializer.aspx

- Chorinator

---

这对我似乎没有起作用，sJON返回空{}。 - Rohit