JSON to DataTable JSON to DataTable json json

JSON to DataTable


This works for me:

using Newtonsoft.Json;string json = "[{"clientID":"1788","projectID":"19"},{"clientID":"1789","projectID":"24"},{"clientID":"1790","projectID":"24"},{"clientID":"1790","projectID":"23"},{"clientID":"1790","projectID":"21"}]";DataTable tester = (DataTable) JsonConvert.DeserializeObject(json, (typeof(DataTable)));


public object Deserialize(string jsonText, Type valueType){    try    {        Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer();        json.NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore;        json.ObjectCreationHandling = Newtonsoft.Json.ObjectCreationHandling.Replace;        json.MissingMemberHandling = Newtonsoft.Json.MissingMemberHandling.Ignore;        json.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;        StringReader sr = new StringReader(jsonText);        Newtonsoft.Json.JsonTextReader reader = new JsonTextReader(sr);        object result = json.Deserialize(reader, valueType);        reader.Close();        return result;    }    catch (Exception ex)    {        throw ex;    }}