How to convert c# generic list to json using json.net?

Question

I am converting my datatable to c# generic list.

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

Now how can i convert this list to json using json.net? Any suggestion.

Sample of json format should be like this,

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

James Newton-King · Accepted Answer · 2012-08-02 00:04:50Z

25

Here's one example:

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", "[email protected]" });
        table.Rows.Add(new[] { "2", "1234567", "[email protected]" });
        table.Rows.Add(new[] { "3", "7654321", "[email protected]" });

        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);
    }
}

Documentation: LINQ to JSON with Json.NET

edited Aug 2, 2012 at 0:04

James Newton-King

49.2k25 gold badges113 silver badges132 bronze badges

answered Aug 14, 2010 at 7:56

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ACP Over a year ago

the example uses linq but i want to use a generic list

Jon Skeet Over a year ago

@Pandiya: So just change the table.AsEnumerable() bit to list. Given that you were using DataTable in your example, I thought you wanted a DataTable as your original source... otherwise why did you bother with that bit of code?

Chorinator · Accepted Answer · 2010-12-30 16:57:49Z

21

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

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

answered Dec 30, 2010 at 16:57

Chorinator

1,37712 silver badges13 bronze badges

1 Comment

Rohit Over a year ago

This does not seems to be working for me, the sJON returns empty {}

Collectives™ on Stack Overflow

How to convert c# generic list to json using json.net?

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related