https://stackoverflow.com/questions/65430927/how-to-convert-json-data-to-datatable

CSharp · Console

/Program.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization.Formatters;
using System.IO;
using System.Data;
using System.ComponentModel.DataAnnotations;
using System.Globalization;
using System.Reflection;
using System.Collections.ObjectModel;

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Newtonsoft.Json.Converters;
using Newtonsoft.Json.Serialization;	

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

//https://stackoverflow.com/questions/65430927/how-to-convert-json-data-to-datatable

	public class DataRoot<T>
	{
		public T Data { get; set; }
		public bool Success { get; set; }
	}

    class TestClass
    {
        public static void Test()
		{
			Test1();
			Test2();
		}

		public static void Test1()
        {
			var result = GetJson();
			
			var root = JsonConvert.DeserializeAnonymousType(result, new { Data = default(DataTable), Success = default(bool) });
			var gdata = root?.Data;
			var success = root?.Success ?? false;

			Console.WriteLine("Success = {0}", success);
			
			Console.WriteLine("gdata: ");
			Console.WriteLine(JsonConvert.SerializeObject(gdata, Formatting.Indented));

			Assert.AreEqual(3, gdata.Rows.Count);
		}	
		
		public static void Test2()
		{
			var result = GetJson();
			
			var root = JsonConvert.DeserializeObject<DataRoot<DataTable>>(result);
			var gdata = root?.Data;
			bool success = root?.Success ?? false;

			Console.WriteLine("Success = {0}", success);
			
			Console.WriteLine("gdata: ");
			Console.WriteLine(JsonConvert.SerializeObject(gdata, Formatting.Indented));
			
			Assert.AreEqual(3, gdata.Rows.Count);
		}
		
		static string GetJson()
		{
			return @"{
""Data"":[
    {
        ""Customer"":""C1"",
        ""ID"":""11111"",
        ""Desc"":""Row 1"",
        ""Price"":""123456""
    },
    {
        ""Customer"":""C2"",
        ""ID"":""22222"",
        ""Desc"":""Row 2"",
        ""Price"":""789012""
    },
    {
        ""Customer"":""C3"",
        ""ID"":""33333"",
        ""Desc"":""Row 3"",
        ""Price"":""345678""
    }
],
""Success"":true
}
";
		}
	}

	public class Program
	{
		public static void Main()
		{
			Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , GetNetCoreVersion());
			Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Assembly.GetName().Name,  typeof(JsonSerializer).Assembly.FullName);
			Console.WriteLine();

			try
			{
				TestClass.Test();
			}
			catch (Exception ex)
			{
				Console.WriteLine("Failed with unhandled exception: ");
				Console.WriteLine(ex);
				throw;
			}
		}
		
		public static string GetNetCoreVersion()
		{
			//https://techblog.dorogin.com/how-to-detect-net-core-version-in-runtime-ecd65ad695be
			//
			var assembly = typeof(System.Runtime.GCSettings).GetTypeInfo().Assembly;
			var assemblyPath = assembly.Location.Split(new[] { '/', '\\' }, StringSplitOptions.RemoveEmptyEntries);
			int netCoreAppIndex = Array.IndexOf(assemblyPath, "Microsoft.NETCore.App");
			if (netCoreAppIndex > 0 && netCoreAppIndex < assemblyPath.Length - 2)
				return assemblyPath[netCoreAppIndex + 1];
			return null;
		}
	}