How to access specific data index in Returned Data Array from aJax Request

Question

Using MVC Pattern, I am trying to find a way to either (1) process Class/Model-type List data into Arrays in MVC Controller for easy index retrieval in View (aJax Function) or (2) send the unprocessed queried data from the Db and process the aJax result into a JSON object or something for easy retrieval of the specific member in the result.

Is there a way to convert a Model-type List into a Collection.Generic.List or generic Array e.g.:

Model-Type List (queryList)

using (var context = new ModelNameDbContext())
{
   List<ModelName> queryList = context.ModelName
                                      .OrderByDescending(x => x.Sn)
                                      .Where(a => a.Stuff== "n1");
}

In the end, I am trying to iterate queryList which might have 30+ members, for instance, into a generic array double[], e.g.:

double[] DataArray;

for (int i = 2; i < 32; i++)
{
    DataArray[i] = queryList[I];       // Having issue here, cannot implicitly convert type Models.ModelName to double
}

So that I can return DataArray to an MVC View through aJax Request to call specific records more easily using indexes in the View:

Controller (C#)

public JsonResult RetrieveAllData()
{
    double? nullCheck;
    List<ModelName> DataArray= new List<ModelName>();
    //double?[] DataArray;
            

    using (var context = new ModelDbContext())
    {
        nullCheck = context.vFarms
                .OrderByDescending(x => x.Sn).Where(a => a.NodeId == "n1").Where(h => h.SnsImeCo2Pd1 == h.SnsImeCo2Pd1)
                .Select(x => x.SnsImeCo2Pd1).FirstOrDefault();

        if (nullCheck is not null)               
        {
            List<ModelName> queryList = context.ModelName
                                                               .OrderByDescending(x => x.Sn)
                                                               .Where(a => a.NodeId == "n1")
                                                               .FirstOrDefault(x => x.Sn == context.vFarms.Max(p => p.Sn));

            METHOD A1.1 - Foreach to iterate
            //var index = 0;
            //foreach (vFarm item in queryList)
            //{
            //    DataArray[index] = item;
            //    index++;
            //}

            METHOD A1.2 - Iterating queried List<> to Generic Array for index parsing in Viewer (METHOD B8)
            //for (int i = 2; i < 34; i++)
            //{
            //    DataArray[i] = queryList[i];
            //}

            METHOD A2 - Passing raw queried List<> to View for parsing
            //DataArray.Add(queryList);
            return Json(DataArray);
        }
        else
        {
            return Json(0.0);
        }
    }
}

View (JavaScript) - aJax Setting & Request

$.ajax({
    url: '../CSV/RetrieveAllData/',
    dataType: "json",
    success: function (result) {

        METHOD B1
        //var data = result.d;
        //for (var i in data) {
        //    alert(JSON.stringify(data[i]));
        //    var y1 = data[i].Data1,
        //        y2 = data[i].Data2;
        //}

        METHOD B2
        //const yAxisArray = JSON.parse(result);

        METHOD B3
        //var yAxisArray = $.parseJSON(result);

        METHOD B4
        //var data = result.d;
        //for (var i in data) {
        //    if (localForInCount == 14) {
        //        var y1 = data[i].Data1;
        //    }
        //    else if (localForInCount == 15) {
        //        var y2 = data[i].Data2;
        //    }
        //    //var y1 = JSON.stringify(data[i].Data1),
        //    //    y2 = JSON.stringify(data[i].Data2);
        //    localForInCount++;
        //}
        //localForInCount = 0;

        METHOD B5
        //$.each(result, function (i, item) {
        var y1 = item.Data1,
            //    y2 = item.Data2;
            //});

        METHOD B6
        //var realArray = eval(JSON.stringify(result));
        //console.log(realArray);
        //var y1 = realArray[14],
        //    y2 = realArray[15];

        METHOD B7
        var parsed_data = JSON.parse(result);
        console.log(parsed_data.success);
        var y1 = parsed_data.SnsImeCo2Pd1,
            y2 = parsed_data.SnsImeCo2Pd2;

        METHOD B8
        //var y1 = result[0],
        //    y2 = result[1];
    }

Alternatively, suggestions for parsing a Model-type Array in Javascript is welcomed too, but I am having issues implementing solutions from here, here and here.

Snippet of aJax Query Result Format

[{"sn":1027,"nodeId":"n1","datapt1":0,"datapt2":0,"datapt3":null}]

probably a case of trying to access the data before the asynchronous request actually receives it, but you haven't shown the code for the request and how it relates to the code that tries to access the result of the erquest — Bravo
– Bravo, Commented Mar 3, 2022 at 0:34
Hey @Bravo, added, hope it clarifies things a bit, I have been trying a few things briefly. But the Controller is currently facing implicit conversion error from class/list -> array while the Viewer has also returned undefined values even though Console.Log shows the result (Just not too sure how to retrieve a specific member value from the aJax result. — Ajax
– Ajax, Commented Mar 3, 2022 at 1:34

Dream Land · Accepted Answer · 2022-03-03 05:06:30Z

0

Just not too sure how to retrieve a specific member value from the aJax result.I think you are asking about how to parse the json data using javascript in client. You get the json converted from an array, the json should look like "[{},{},...]".You can easily use index to traverse it. e.g

//javascript
jsonData = "[{"sn":1027,"nodeId":"n1","datapt1":0,"datapt2":0,"datapt3":null}]";
var dataYouwant = jsonData[0];

But make sure the json is in correct format. Additional " and \ could cause error when parse the json data in javascript. If this occures, give JSON.parse() a try.

edited Mar 3, 2022 at 5:06

answered Mar 3, 2022 at 3:15

Dream Land

417 bronze badges

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

Collectives™ on Stack Overflow

How to access specific data index in Returned Data Array from aJax Request

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