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

by

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

More Related Contents:

  1. parse JSON using json.net c# [closed]
  2. How can I parse a JSON string that would cause illegal C# identifiers?
  3. How to convert JSON to XML or XML to JSON?
  4. Casting interfaces for deserialization in JSON.NET
  5. Deserialize json with known and unknown fields
  6. How to show the “paste Json class” in visual studio 2012 when clicking on Paste Special?
  7. Is it worthwhile to initialize the collection size of a List if it’s size reasonably known?
  8. How to deserialize a JSON property that can be two different data types using Json.NET
  9. How to initialize a List to a given size (as opposed to capacity)?
  10. Newtonsoft Json.Net serialize JObject doesn’t ignore nulls, even with the right settings
  11. Iterating over JSON object in C#
  12. Json.NET custom serialization with JsonConverter – how to get the “default” behavior
  13. Send JSON via POST in C# and Receive the JSON returned?
  14. Deserializing heterogenous JSON array into covariant List using Json.NET
  15. Find and return JSON differences using newtonsoft in C#?
  16. Ignoring null fields in Json.net
  17. How can I tell Json.NET to ignore properties in a 3rd-party object?
  18. Convert DataTable to JSON with key per row
  19. Deserialize specific enum into system.enum in Json.Net
  20. Json.net serialize numeric properties as string
  21. Using Custom WCF Body Deserialization without changing URI Template Deserialization
  22. Json.Net PopulateObject – update list elements based on ID
  23. Serialize/Deserialize dynamic property name using JSON.NET
  24. How do I get formatted and indented JSON in .NET using C#?
  25. How to deserialize a property with a dash (“-”) in its name with NewtonSoft JsonConvert?
  26. Serializing/Deserializing Dictionary of objects with JSON.NET
  27. Configure Json.NET serialization settings on a class level
  28. JSON.NET Serializes Empty JSON
  29. SignalR Typenamehandling
  30. Generate JSON object with NewtonSoft in a single line

Leave a Comment