Serializing a C# object into a multidimensional JSON array of a specific type

Question

I'm working with Highcharts that wants data in the following format and I'm having trouble achieving it:

var data = [
    ["CityName", 1234],
    ["City2", 12123]
]

etc...

So, I'm needing this formatted like the above array and simply can't seem to achieve it.

I've seen this from JSON.NET:

string[,] famousCouples = new string[,]
  {
    { "Adam", "Eve" },
    { "Bonnie", "Clyde" },
    { "Donald", "Daisy" },
    { "Han", "Leia" }
  };

string json = JsonConvert.SerializeObject(famousCouples, Formatting.Indented);
// [
//   ["Adam", "Eve"],
//   ["Bonnie", "Clyde"],
//   ["Donald", "Daisy"],
//   ["Han", "Leia"]
// ]

That's fine for strings, but how about string and a float together? This is a requirement as one of the numbers needs to aggregate over a list and string[,] really isn't an ideal object to work with.

At the minute I'm using List<Dictionary<string,float> (this would also be the result with a custom object) and the serializer is outputting data as:

var data = [
   {"CityName", 1234}
]

etc.

I may be missing something really simple, but is there any way to achieve this?

T.J. Crowder · Accepted Answer · 2014-09-28 15:07:57Z

2

I think you probably want object[,]:

object[,] cityNames = new object[,] {
    {"CityName", 1234},
    {"City2", 12345 }
};

answered Sep 28, 2014 at 15:07

T.J. Crowder

1.1m201 gold badges2k silver badges2k bronze badges

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

3 Comments

Chris Dixon Over a year ago

Interesting, let me have a crack at that and see if it works :) If so, it'll have saved me for today!

T.J. Crowder Over a year ago

@ChrisDixon: The theory is sound, but we'll see if it survives contact with experimental reality. :-) (I don't have JSON.Net handy, you see.)

T.J. Crowder Over a year ago

@ChrisDixon: Cool! I'm glad that worked! FWIW, it doesn't work with System.Web.Script.Serialization.JavaScriptSerializer. In what I can only consider a flat-out bug in JavaScriptSerializer, it outputs ["CityName", 1234, "City2", 12345] (note that that's just one dimension). Glad JSON.Net gets it right.

Collectives™ on Stack Overflow

Serializing a C# object into a multidimensional JSON array of a specific type

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related