how i could iterate over json array of array

Question

i want to iterate over a json array of arrays from th controller i want to know how i could iterate over it

i need help: nay could help me i'm new to json and mvc

//server code

        var jsonData = new
        {

            rows =
            (from bathymetrie in bathymetries

             select new
             {
                 count = bathymetries.Count,
                 Id = bathymetrie.Id,
                 date = (bathymetrie.displayedDate != null) ? 
        bathymetrie.displayedDate.ToString() : ""
             }).ToArray()
        };


  //client code

 success: function (data) {

            bathyms = "{";

            for (var i = 0; i < data[1].count; i++) {

                bathyms += el[i].Id + " : " + el[i].date;

                alert(el[i].Id);
                alert(el[i].date);
                console.log(el[i].date);

                if (i != data[0].count) {

                    bathyms += ",";
                }

            }
            bathyms += "}";
        }

Andrei · Accepted Answer · 2014-02-19 16:17:03Z

1

Your data is an object with single field row, which contains an array of objects. Thus, iteration should look like this:

for (var i = 0; i < data.rows.length; i++) {
    var element = data.rows[i];
    // use element.Id, element.count and element.date

answered Feb 19, 2014 at 16:17

Andrei

56.8k10 gold badges92 silver badges114 bronze badges

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

Comments

ramiramilu · Accepted Answer · 2014-02-19 16:24:02Z

Say if you have your model like this -

public class Data
{
    public int Id { get; set; }
    public int Count { get; set; }
    public string Date { get; set; }
}

And you are returning JsonResult of Array object like this -

    public ActionResult GetJson()
    {
        Data[] a = new Data[2];
        a[0] = new Data() { Count = 10, Id = 1, Date = "2/19/2014" };
        a[1] = new Data() { Count = 20, Id = 2, Date = "3/19/2014" };

        return new JsonResult() { Data = a };
    }

Then you can invoke this action in JQuery in the following way -

<script src="~/Scripts/jquery-1.10.2.min.js"></script>
<script>
    function submitForm() {
        jQuery.ajax({
            type: "POST",
            url: "@Url.Action("GetJson")",
            dataType: "json",
            contentType: "application/json; charset=utf-8",
            success: function (data) {
                $.each(data, function (key, value) {
                    alert(value.Id + ' ' + value.Count + ' ' + value.Date);
                });
            },
            failure: function (errMsg) {
                alert(errMsg);
            }
        });
    }
</script>

<input type="button" value="Click" onclick="submitForm()" />

Please observe following code which will iterate array -

        success: function (data) {
            $.each(data, function (key, value) {
                alert(value.Id + ' ' + value.Count + ' ' + value.Date);
            });

Output would be N number of alerts based on N elements in array like below -

enter image description here

Collectives™ on Stack Overflow

how i could iterate over json array of array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related