Data format for generating table with json mvc ASP.NET

Question

I'm doing some queries in the database and must return through the Json, but I can not hit the fomato. I'm doing the following:

var dataResult = new List<List<Object>>();

I query the database and and add below

dataResult.Add(new List<object>(new object[] { "rRod:" + rod, "rKmI:" + vlrkmI, "rKmF:" + vlrkmF, "rExt:" + ext, "rSol:" + sol }));

To assemble the table use

function (data) {
    $("#divResult").empty();

    //Adicionar a tabela na div
    table = "<fieldset style='height:50px '><legend>Resultado da Matriz</legend><table id='tableResult'><tr><th>Rod</th>";
    table += "<th>kmI</th><th>kmF</th><th>Ext</th><th>Sol</th></fieldset>"
    $("#divResult").append(table);

    $(eval(data)).each(function (data) {
    $("#tableResult").append(
        "<tr><td>" + this.rRod+ "</td>" + 
        "<td>" + this.rKmI + "</td>" + 
        "<td>" + this.rKmF + "</td>"
        "<td>" + this.rExt + "</td>" +
        "<td>" + this.rSol + "</td></tr>");
});

But not this genrando the table with values.

Sorry I don't know what you are doing. Could you read this and try again? msmvps.com/blogs/jon_skeet/archive/2010/08/29/… — Aron
– Aron, Commented May 27, 2014 at 13:16
What I'm wondering is how should be the format of the json output to generate a table. — rysahara
– rysahara, Commented May 27, 2014 at 13:22

qamar · Accepted Answer · 2014-05-28 16:18:57Z

1

What I would suggest you to do is instead of doing a list of object create a class with those properties something like this :

var dataResult = new List<List<sometypewhichhasallofthosejsobproperties>>();

Now from the mvc action just simply return jsonresult of the dataresult. This should format your data to json nicely and you should be able to work with it in jquery easily.

answered May 28, 2014 at 16:18

qamar

1,4471 gold badge10 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Data format for generating table with json mvc ASP.NET

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