How to convert json into datatable?

by

Assuming that your JSON string is a list of objects, each object will correspond to a row in the DataTable, viz:

    public DataTable DerializeDataTable()
    {
        const string json = @"[{""Name"":""AAA"",""Age"":""22"",""Job"":""PPP""},"
                           + @"{""Name"":""BBB"",""Age"":""25"",""Job"":""QQQ""},"
                           + @"{""Name"":""CCC"",""Age"":""38"",""Job"":""RRR""}]";
        var table = JsonConvert.DeserializeObject<DataTable>(json);
        return table;
    }

This requires the Json.NET framework.

If your JSON structure is different please post it. Best Regards.

More Related Contents:

  1. How do I use JSON.NET to deserialize into nested/recursive Dictionary and List?
  2. Can Json.NET serialize / deserialize to / from a stream?
  3. Using Json.NET converters to deserialize properties
  4. How to localize when JSON-serializing?
  5. Ensuring json keys are lowercase in .NET
  6. How to deserialize a JObject to .NET object
  7. Json.NET serializing float/double with minimal decimal places, i.e. no redundant “.0”?
  8. Is datareader quicker than dataset when populating a datatable?
  9. Deserialize using JSON.net
  10. replace WCF built-in JavascriptSerializer with Newtonsoft Json.Net json serializer
  11. Ignore a property during xml serialization but not during deserialization
  12. JSON.NET JsonConvert vs .NET JavaScriptSerializer [closed]
  13. Get Raw json string in Newtonsoft.Json Library
  14. Fastest way to convert datatable to generic list
  15. How to remove k__BackingField from json when Deserialize
  16. .NET DataTable skips rows on Load(DataReader)
  17. What’s the best way to jSON serialize a .NET DataTable in WCF?
  18. LINQ to SQL Left Outer Join
  19. Pros and cons of AppSettings vs applicationSettings (.NET app.config / Web.config)
  20. How do I invert BooleanToVisibilityConverter?
  21. HashSet versus Dictionary w.r.t searching time to find if an item exists
  22. Why does a Linq Cast operation fail when I have an implicit cast defined?
  23. Why should I always make my Exceptions [serializable]? (.NET)
  24. Making DataGridView rows a certain color based on a column value
  25. How can I force .NET to use a local copy of an assembly that’s in the GAC
  26. How to apply indenting serialization only to some properties?
  27. HRESULT: 0x80131040: The located assembly’s manifest definition does not match the assembly reference
  28. How does Copy-local work? log4net.dll is not being copied to MyProject output directory
  29. Using entity framework on multiple databases
  30. variable/property changed event in vb.net

Leave a Comment