Read retrieved json data using jquery in View mvc 3

Question

I declared and serialized data on my View page

@model IEnumerable<MVCvs2012.Models.Employees>

 @{
    var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
    var employees = @serializer.Serialize(ViewData["Employees"]);   
  }

Results when running the browser:

[{"FirstName":"Nancy","LastName":"Davolio","Title":"Sales Representative"}]

I want to present this data using jquery into a table like this:

<table id="employee">
<tr>
  <td>Nancy</td>
  <td>Davolio</td>
  <td>Sales Representative</td>
</tr>
...
</table>

Im lost why you are using JSON format to send C#/Razor data. Seems more sensible to pass your list to your view and render it with a for each loop. — Dave Alperovich
– Dave Alperovich, Commented Sep 26, 2013 at 16:58
Yes, I tried that method and it is a 100% , but I'm trying to find a way to display those data without refreshing the page and by just clicking on a button, you can have those data appended to a table in your view — Francis Padron
– Francis Padron, Commented Sep 26, 2013 at 17:08
OIC, consider using a partial view with child action for your report. Then request a new one with JQuery .load() — Dave Alperovich
– Dave Alperovich, Commented Sep 26, 2013 at 20:24
Correct me if I'm wrong, There's a caching going on when using Partial View? and using jquery .load() you can get those cached data and store them on a var or something? — Francis Padron
– Francis Padron, Commented Sep 26, 2013 at 21:27
when you use a jquery .load(), it overwrites caching. I use .load() with partials for all incremental behaviors. Can be used to refresh a report or to add more data by passing a parameter. — Dave Alperovich
– Dave Alperovich, Commented Sep 26, 2013 at 23:17

Linell · Accepted Answer · 2013-09-26 17:03:27Z

1

Use jQuery.each to build your table. Something along the lines of

$var table = '<table>';
$.each(yourJson, function( index, value ) {
      $table += '<tr><td>' + value.FirstName + '</td><td>' + ...
});
$table += '</table>';

answered Sep 26, 2013 at 17:03

Linell

7593 gold badges9 silver badges29 bronze badges

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

2 Comments

Francis Padron Over a year ago

How can I put my serialized data(employees) on a var(yourJason)? that I can call from my jquery

Linell Over a year ago

I haven't used MVC in a while, but you just need to store it as some sort of variable, then you can put it in. So like var data = @GetItFromYourController, then just call it as $.each(data ..

Collectives™ on Stack Overflow

Read retrieved json data using jquery in View mvc 3

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