How to use Json in C# MVC to create a 2 dimensional array

Question

Now I have this class

public class FooResult
{
    public int sEcho;
    public Foo[] aaData;
    internal FooResult()
    {
        sEcho = 1;
        aaData = new FooRepository().GetAll().ToArray();
    }
}

new FooRepository().GetAll().ToArray(); returns an array of Foos.

When I use System.Web.Mvc.Controller.Json to convert this FooResult into a JsonResult, I got the string in Json Format like this:

{"sEcho":3, "aaData":[{"Name":"BarName"},{"Name":"FooName"}]}

However, I want the aaData to be a two dimensional array instead of an array of objects, which means it should be in this format:

{"sEcho":3, "aaData":[["BarName"],["FooName"]]}

How can I do that?

What you want is invalid JSON. Not sure what you are expecting — Simon Belanger
– Simon Belanger, Commented Jan 21, 2014 at 11:24
The commas were an obvious mistake. The invalidity is within the array itself. You can't have ["key":"value"]. You can have `["key","value"] is you want. — Simon Belanger
– Simon Belanger, Commented Jan 21, 2014 at 11:28

Grundy · Accepted Answer · 2014-01-21 11:37:21Z

1

for this case you can use something like this

internal FooResult()
{
    sEcho = 1;
    aaData = new FooRepository().GetAll()
                                .Select(foo=>new object[]{
                                    foo.Name
                                    /*other fields what need*/
                                 })
                                .ToArray();
}

OR you can change settings for plugin DataTables and send array of objects

NOTE
Change type aaData from Foo[] to object[][]

answered Jan 21, 2014 at 11:37

Grundy

13.4k3 gold badges39 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

How to use Json in C# MVC to create a 2 dimensional array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related