Converting a DataTable to nested JSON output C#

Question

I have a SQL Server source table defined as:

CstCmpCode Main_Group Sub_Group ClosBal
AH01 Neck Wraps AFGHANI 7

I need the output to be:

{
  "CstCmpCode": "AH01",
  "Main_Group": "Neck Wraps",
  "sub_group": [
    {
      "Sub_Group": "AFGHANI",
      "ClosBal": 7
    }
  ]
}

I have the source SQL Server table being imported to a DataSet, then was going to use JSON.NET to parse the results. I was thinking I should create some sort of Class structure with a main_group having a list of sub_group/closbal key/value pairs, but I'm not totally sure if that's the right track or not.

Thanks. Yogesh.Sharma

Tabish Usman · Accepted Answer · 2016-08-16 06:11:25Z

2

you can directly do it by using following code(with Newtonsoft Json.NET).

string JSONresult;
JSONresult = JsonConvert.SerializeObject(yourDataTable);

answered Aug 16, 2016 at 6:11

Tabish Usman

3,2702 gold badges19 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yogesh Sharma Over a year ago

but, my json string is not getting upgdated with nested json string

Tabish Usman Over a year ago

In this case your approach is the right one, for reference your can use this link. stackoverflow.com/questions/15628569/nested-json-from-datatable

Mahdi · Accepted Answer · 2016-08-16 09:40:10Z

0

If you need this output you should have a class like this:

public class SubGroup
{
    public string Sub_Group { get; set; }
    public int ClosBal { get; set; }
}

public class RootObject
{
    public string CstCmpCode { get; set; }
    public string Main_Group { get; set; }
    public List<SubGroup> sub_group { get; set; }
}

An objects of this class can be serialized to the JSON format you mentioned.

answered Aug 16, 2016 at 9:40

Mahdi

3,3892 gold badges29 silver badges37 bronze badges

1 Comment

Yogesh Sharma Over a year ago

directly it is possible ? without implementing the for loop for datatable

Collectives™ on Stack Overflow

Converting a DataTable to nested JSON output C#

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related