using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Collections.ObjectModel;

using System.Reflection;

using System.Runtime.Serialization;

using System.Data;

using System.Xml;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;

​

namespace Question42177475

{

    // https://stackoverflow.com/questions/42177475/issue-converting-json-string-to-datatable-c-sharp

    public class Result

    {

        public int ID { get; set; }

        public string Reference { get; set; }

        public int Asset { get; set; }

        public int Event { get; set; }

        public string DateEventStart { get; set; }

        public string DateEvent { get; set; }

    }

​

    public class RootObject<T>

    {

        public int Code { get; set; }

        public T Result { get; set; }

    }

​

    internal class TestClass

    {

        static string GetJson()

        {

            var json = @"{

  ""Code"": 0,

  ""Result"": [

    {

      ""ID"": 1,

      ""Reference"": ""101"",

      ""Asset"": 200,

      ""Event"": 1,

      ""DateEventStart"": ""2/10/2017 9:08:33 PM"",

      ""DateEvent"": ""2/11/2017 1:00:14 AM""

    }

]

}";

            return json;

        }

​

        internal static void Test()

        {

            var responsetext = GetJson();

​

            var rootOfList = JsonConvert.DeserializeObject<RootObject<List<Result>>>(responsetext);

            var rootOfTable = JsonConvert.DeserializeObject<RootObject<DataTable>>(responsetext);

            DataTable table = rootOfTable.Result;

​

            Console.WriteLine(string.Format("Result of deserializing and reserializing as a {0}:", rootOfList.GetType()));

            Console.WriteLine(JsonConvert.SerializeObject(rootOfList, Newtonsoft.Json.Formatting.Indented));

​

            Console.WriteLine(string.Format("Result of deserializing and reserializing as a {0}:", rootOfTable.GetType()));

            Console.WriteLine(JsonConvert.SerializeObject(rootOfTable, Newtonsoft.Json.Formatting.Indented));

        }

    }

}

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Json.NET version: " + typeof(JsonSerializer).Assembly.FullName);

        Console.WriteLine("");

        Question42177475.TestClass.Test();

    }

}