Convert Single column C# DataTable to JSON using JSON.NET

Question

The DataTable contains single column EFFDATE.

EFFDATE
2015-06-15
2014-10-21
2014-07-17
2014-07-16
2014-06-17
2014-03-13

I have the following code to convert DataTable dttbl to JSON.

JsonConvert.SerializeObject(dttbl, Formatting.Indented)

The output from conversion is

[
  {
    "EFFDATE": "2015-06-15"
  },
  {
    "EFFDATE": "2014-10-21"
  },
  {
    "EFFDATE": "2014-07-17"
  },
  {
    "EFFDATE": "2014-07-16"
  },
  {
    "EFFDATE": "2014-06-17"
  },
  {
    "EFFDATE": "2014-03-13"
  }
]

The output I want is

{
    "EFFDATE": [
        "2015-06-15",
        "2014-10-21",
        "2014-07-17",
        "2014-07-16",
        "2014-06-17",
        "2014-03-13"
    ]
}

Please advice.

no way... JSON needs to explicit the column names in each object — lem2802
– lem2802, Commented Jul 29, 2015 at 15:52
Does JSON needs to explicit the column or JSON.net needs to do that? The expected JSON is valid. So I think I got to custom-create my own JSON from the DataTable. — stackoverflowuser
– stackoverflowuser, Commented Jul 29, 2015 at 15:57

EZI · Accepted Answer · 2015-07-29 15:55:32Z

1

var json = JsonConvert.SerializeObject(
              new { EFFDATE = dt.AsEnumerable().Select(r => r[0]) }
           );

answered Jul 29, 2015 at 15:55

EZI

15.4k2 gold badges29 silver badges33 bronze badges

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

2 Comments

EZI Over a year ago

@stackoverflowuser If you liked it you may want to accept it. meta.stackexchange.com/questions/5234/…

stackoverflowuser Over a year ago

I was not allowed to. Had to wait for few minutes. Just did.

Collectives™ on Stack Overflow

Convert Single column C# DataTable to JSON using JSON.NET

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related