Converting Dataset to Json with Empty datatable's columns

Rameez Javed

Hi everyone, I want to convert DataSet to Json using newtonsoft. I converted it successfully but an issue here is the datatable with 0 rows are column less in json.

I'm getting the json like below, but I want to have dt_3 with its columns names.

What I'm doing is

string json_withoutStoreDetails = JsonConvert.SerializeObject(dset, Newtonsoft.Json.Formatting.Indented);

{
"dt_1": [
{
"depid": 51.0,
"DepName": "Honda",
"Amount": 110.50
},
{
"depid": 54.0,
"DepName": "Toyota",
"Amount": 100.60
},
{
"depid": 56.0,
"DepName": "Diahatsu",
"Amount": 120.00
},
{
"depid": 57.0,
"DepName": "Bedford",
"Amount": 380.00
},
],
"dt_2": [
{
"depid": 50,
"DepName": "AlloyRims",
"Amount": 21.50
}
],
"dt_3": [
],
}

3 Replies

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

Sachin Singh5y ago
its an issue
https://github.com/JamesNK/Newtonsoft.Json/issues/1343
and solution is to ovverride json converter
https://stackoverflow.com/questions/33499760/how-to-include-column-metadata-in-json-for-an-empty-datatable
0
Rameez Javed5y ago
I'm converting dataset and getting the fine result but the issue is some datatables in dataset are empty and for those datatable im getting empty json string (only table names) but I want column names if datatable are empty...
0
Sachin Singh5y ago
now kindly reverse this and test , even if your json is null but when it is converted to datatable you get the exact same datatable as before.
string json = JsonConvert.SerializeObject(YourDataTable, Formatting.Indented);

Now Convert your Json to a DataTable:

YourDataTable = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable)));
0