Iterate DataTable serialized through Json.Net in jQuery

Question

I found this awesome tip here at how to serialize a .Net DataTable into a Json String using Json.Net with the following code:

  return JsonConvert.SerializeObject(dtProdEv, Formatting.Indented);

I get the following result back:

[
  {
    "Col1": 2,
    "Col2": "\/Date(1292724000000-0200)\/",
    "Col3": 0,
    "Col4": 1,
    "Col5": "\/Date(1292772960760-0200)\/",
    "Col6": null,
    "Col7": null,
    "Col8": 0.0000,
    "Col9": 0,
    "Col10": 1
  },
  {
    "Col1": 2,
    "Col2": "\/Date(1292724000000-0200)\/",
    "Col3": 0,
    "Col4": 2,
    "Col5": "\/Date(1292773781763-0200)\/",
    "Col6": 3,
    "Col7": 1,
    "Col8": 0.0000,
    "Col9": 0,
    "Col10": 2
  }
]

My question is how can I iterate through this result using JQuery? I parse it into an Object using parseJSON, but then I'm stumped. Tks

Zain Shaikh · Accepted Answer · 2010-12-19 20:11:51Z

2

You can use $.each to iterate through the whole array.

See the live demo here.

// loop through the array of objects.
$.each(data ,function(i,item){

    // document.write(item["Col7"]); // print specific property


    // loop through the properties of each object.
    $.each(item, function(j, child){

        document.write(child); // print all the childs

    });

});

answered Dec 19, 2010 at 20:11

Zain Shaikh

6,0636 gold badges44 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Iterate DataTable serialized through Json.Net in jQuery

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related