ansaurus

Question

Answer 1

+6 A:

I've been trying to solve the same problem for the last couple of hours. I've now given up on getting AddJSONData working - my web service method is returning an array so it looks like using addRowData will work.

function ReceivedClientData(data) {
        var thegrid = $("#list4");
        for (var i = 0; i < data.length; i++) {
            thegrid.addRowData(i+1, data[i]);
        }
    }

2009-02-14 08:25:55

thank you, this is solution :)please someone put Tom's answer as answer :)cheers

Marko 2009-08-24 09:23:20

If you aren't paging, you could embed the rows into an object tag...{ 'page':1, 'total':1, 'records':rows.length, 'records':rows } and use that with addJSONData.

Tracker1 2010-03-10 23:42:34

this is solution with little modifications depending on what you get from webservice...for me it is: success: function(jsondata, stat) { var thegrid = $("#list"); var evaluated = JSON.parse(jsondata.d); for (var i = 0; i < evaluated.length; i++) { thegrid.addRowData(i + 1, evaluated[i]); } }

Marko 2010-09-22 16:09:12

Answer 2

A:

Actually, the key seems to be the parameters on addJSONData which don't appear in the docs:

function ReceivedClientData(data) {
        var thegrid = $("#rowed2");
        thegrid[0].addJSONData(data,thegrid.bDiv,9)            
    }

The web method that goes with that is :

    [WebMethod(EnableSession = true)]
    public object GetTestClients(int pagenum, int rows)
    {
        var lst = Session["lst"] as List<Entities.Client>;
        if (lst == null)
        {
            lst = new List<Entities.Client>();
            for (int i = 1; i <= 5; i++)
            {
                lst.Add(new TF.WebApps.Entities.Client()
                {
                    ClientID = "Client" + i,
                    Firstname = "first" + i,
                    Lastname = "last" + i
                });
            }
            Session["lst"] = lst;
        }
        var v = from c in lst
                select new
                {
                    id = c.ClientID,
                    cell = new object[] 
                    {
                        c.ClientID,
                        c.Firstname,
                        c.Lastname
                    }
                };

        var result = new
        {
            total = v.Count() / rows,
            page = pagenum,
            records = rows,
            rows = v.Skip((pagenum-1)*rows).Take(rows).ToArray()
        };


        return result;
    }

2009-02-14 15:28:08

Answer 3

A:

The setup of the jqGrid looks fine.

Are you certain that what you get back in the jsondata.responseText is what you describe?

The webservice that I write in .NET returns JSON formatted like this: {"d": "{”page”:”1″,”total”:”10″,”records”:”160″,”rows”:[{"id":"18","cell":"["18","BAM","Konvertibilna marka","977"]“}"

In my function I had to do this:

complete: function(data) { var stuff = JSON.parse(data.responseText); jQuery("#grid")[0].addJSONData(JSON.parse(stuff.d)); }

I had to convert the string to JSON two times before I actually got the data I needed.

If you're having great problems. I suggest debugging this piece by piece. Execute a simple statement such as this:

jQuery("#list")[0].addJSONData(JSON.parse("{total: 1, page: 1, records: 1, rows : [ {id: '1', cell:['1', '2007-10-01', 'test', 'note', 'new', '200.00', '10.00', '210.00']} ] }"));

That should work at the very least. After that, just analyze the output you get from the web service and ensure that you can just get that statement to execute for 'complete'.

Lobut 2009-02-15 03:24:02

I get json like the one posted because i use non .net JSON serializer.

MilosC 2009-02-16 04:46:21

Right, just double-checking.Did you try attempting to just execute the function on your own, during the document.ready or during an onclick function?Just to see if it adds it on its own?

Lobut 2009-02-16 05:26:09

Answer 4

A:

thanks, this works for me:

mygrid[0].addJSONData(result, mygrid.bDiv, 0);

or try this:

mygrid[0].addJSONData($.toJSON(result), mygrid.bDiv, 0);

my grid datatype is jsonstring

gr

Atam Panday

2009-04-21 20:57:29

Answer 5

A:

I'm also using a webservice to pass data to a jqGrid. I ran into the same problem and here is the code in the complete portion of the .ajax function.


complete: function(jsondata, stat) {
             if (stat == "success") {
                var thegrid = jQuery("#list2")[0];
                var jsonObject = eval('(' + jsondata.responseText + ')');
                thegrid.addJSONData(jsonObject.d);
             }
           }

The key is the .d after the responseText is evaluated into a JSON Object.

Frenchie 2009-09-30 14:58:02

Answer 6

A:

I know it's old, but this is probably your issue...

Make row.cell a List, then you can do...

row.cell = new List {
    dr["DenarnaEnotaID"]
    ,dr["Kratica"]
    ,dr["Naziv"]
    ,dr["Sifra"]
};

On the script side...

var myjsongrid = eval('('+clearJson+')');
...
thegrid.addJSONData(myjsongrid.replace(/\\/g,''));

myjsongrid is an Object at this point, there generally isn't a .replace method on objects. Also, you should probably use a JSON parser insted of the eval. I use a modified version of Crockford's json2.js myself but YMMV.

This should make each row how you want it, letting the serializer handling the conversion... I actually serialize my datatables to { columns:['colname',...], rows:[['row1val',...],['row2val',...],...] } and frob it client-side as I use some of the same calls to populate various grids... I have a client-side selectForJqGrid(table, keycol, [col list]) that will set it up for use direct to a jqGrid.

Tracker1 2010-03-10 23:40:23

ansaurus

tags:

views:

answers:

JqGrid addJSONData + ASP.NET 2.0 WS

related questions