How to convert a linq array to string array for json

Question

i have this function in VB.NET

Dim dt = (From d In db.d ...).ToArray()

Return New With {
    .label = "label",
    .data = dt.ToArray()
}

that returns the following data in JSON format

{
    "label":"label",
    "data":[
        {"date":1366657400000,"value":12051},
        {"date":1366657397000,"value":12102},
        {"date":1366646820000,"value":12099}
    ]
}

How can I go about returning the data in the following format

{
    "label":"label",
    "data":[
        [1366657400000,12051],
        [1366657397000,12102],
        [1366646820000,12099]
    ]
}

Are you sure you want to do this? The original JSON looks better to me. — svick
– svick, Commented Apr 22, 2013 at 20:37
@svick I agree, but I need to do so in order for Flot plugin to work! — sdagkas
– sdagkas, Commented Apr 23, 2013 at 21:30

qxn · Accepted Answer · 2013-04-22 19:48:37Z

1

I'm not very familiar with VB, but it should look something like this:

Return New With { _
    .label = "label", _
    .data = data.[Select](Function(d) New Long() { d.date, d.value} ).ToArray() _
}

The idea is that you want to create a new array for each item in your original collection. The first item in the new array is the date property, and the second item is the value property.

This is what it would look like in C#:

return Json(new {
    label = "label",
    data = data.Select(d => new[] { d.date, d.value }).ToArray()
});

edited Apr 22, 2013 at 19:48

answered Apr 22, 2013 at 19:33

qxn

17.6k3 gold badges55 silver badges72 bronze badges

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

8 Comments

sdagkas Over a year ago

Sorry, that doesn't compile. I tried Return New() With { .label = "label", .data = data.ToArray() } but it gives me a syntax error 'Type expected'

sdagkas Over a year ago

I know how to write it in c#, I found a similar answer here but I don't know how to convert d => new[] to VB. The syntax New() With doesn't compile.

shahkalpesh Over a year ago

Write new string() in place of new[], to start with - assuming its going to be a string array.

qxn Over a year ago

@Elio - Sorry... as I said, I don't know VB very well. But the method is correct: create a new array from each item in the original data collection. That way, an array of arrays is serialized, and you should get your desired output.

qxn Over a year ago

@Elio - I fixed the VB example. It now compiles and works for me.

|

Collectives™ on Stack Overflow

How to convert a linq array to string array for json

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related