How to convert Json Object to DataTable in Asp.Net Core

Adhikar Patil

7y9.8kLearn iOS Programming

Hello,

I want to convert Json object to DataTable. I have json file to insert bulk data into table using SqlBulkCopy

string contentRootPath = _appSettings.MasterJsonPath;

var folderDetails = Path.Combine(Directory.GetCurrentDirectory(),$"wwwroot\\{"MasterData\\masterdata.json"}");

var JSON = System.IO.File.ReadAllText(folderDetails);

dynamic jsonObj = Newtonsoft.Json.JsonConvert.DeserializeObject(JSON);

var response = 0;

DataTable dt = (DataTable)jsonObj["M203StructureKind"].AsDataReader();

SqlBulkCopy bulk = new SqlBulkCopy("Data Source = DESKTOP-JENGCSC;

Initial Catalog=BdsDb; Integrated Security=True;");

bulk.DestinationTableName = "M203StructureKind";

bulk.WriteToServer(dt);

So i am getting exception like Cannot convert type 'Newtonsoft.Json.Linq.JArray' to 'System.Data.DataTable while converting the json object to datatable

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R7y ago
Hi,

Can you check with the below link:

https://www.youtube.com/watch?v=2C1SOPMiQmc
0

Amit Mohanty7y ago

Try this

public static DataTable JsonToDataTable(string jsonString)
{
var jsonLinq = JObject.Parse(jsonString);
// Find the first array using Linq
var srcArray = jsonLinq.Descendants().Where(d => d is JArray).First();
var trgArray = new JArray();
foreach (JObject row in srcArray.Children())
{
var cleanRow = new JObject();
foreach (JProperty column in row.Properties())
{
// Only include JValue types
if (column.Value is JValue)
{
cleanRow.Add(column.Name, column.Value);
}
}
trgArray.Add(cleanRow);
}
return JsonConvert.DeserializeObject(trgArray.ToString());
}