JSON parse/load data error

Suite and Optimus Suite 5
#1

Hi team,
I spent 2 days trying to fix this problem, and searched in this forum many times but couldn’t find an answer.

I am creating/ returning a JSON from my controller as the following:

private JsonResult GetCustomers()
{
var customers = from s in db.Customers
select s;

        var retValue = customers.Select(
            x => new
            {
                id = x.CustomerId,
                fname = x.First_Name,
                lname= x.Last_Name
            }).ToList();

        JavaScriptSerializer serializer = new JavaScriptSerializer();
        return Json(new { Data = serializer.Serialize(retValue) }, JsonRequestBehavior.AllowGet);
    }

the returned JSON is:
{“Data”:{“ContentEncoding”:null,“ContentType”:null,“Data”:{“Data”:"[{“id”:14,“fname”:“Sim”,“lname”:“Yoak”},{“id”:15,“fname”:“Cheel”,“lname”:“Pink”},{“id”:16,“fname”:“Pa Poon”,“lname”:“Chok”},“JsonRequestBehavior”:0,“MaxJsonLength”:null,“RecursionLimit”:null}}

on the view i have:

mygrid.load("/Home/GetCustomers", “jsarray”);

I also tried : mygrid.load("/Home/GetCustomers", “js”); and no luck

Am i missing something here? all i need is to load the data from my model to the Grid

#2

jsArray expects the data to look like this:

   [ ['row1 col1', 'row1 col2', 'row1 col2'], ['row2 col1', 'row2 col2', 'row2 col2'] ]

This is an array of comma separated columns.

Here’s a sample: dhtmlx.com/docs/products/dhtmlxG … array.html

If you use chrome and inspect element, then go to the network tab - refresh the page and look at the response of data.js.

If you want to use pure json, it has a different data format and there are json samples you can find. Whatever format you use, make sure it is formatted exactly as dhtmlx is expecting.

I have found that using the pure json format is better because you can set an id for each column (this is also possible in xml).

#3

Correction of last sentence:

I have found that using the pure json format is better because you can set an id for each ROW (this is also possible in xml).

#4

Thanks for the reply, but how can i format the JSON file i created to meet the Grid requirements?

#5

Is there a way to use the connector in this case? if so how can i integrate The connector with my MVC application.

#6

Unfortunately it’s not available to generate the json using the dhtmlxConnector.