ansaurus

Question

jqGrid, ASP.NET, JSON is Driving me crazy. Please Help.

Answer 1

+2 A:

missing an identifier for that list:

return_value = {
    total:1,
    page:1,
    records:5,
    [{  .. some X12 messages  ..}]
}

Jimmy 2009-04-07 01:26:42

Answer 2

+1 A:

It doesn't look like you are adding the rows property identifier. Try changing:

json.Append(JsonConvert.SerializeObject(objPageCollection))

to

json.Append("rows: " + JsonConvert.SerializeObject(objPageCollection))

If this doesn't work, I suggest that you simplify the problem -- reduce the data to one row, for example -- and see if you can get it working with simpler data, then gradually add more stuff back into it.

tvanfosson 2009-04-07 01:28:42

Answer 3

A:

Actually, tvanfosson makes an excellent point with the requirement of the 'rows' identifier. I'm unfamiliar with jMSAjax so my comments may be null and void. I'm glad to be aware of it.

Could it be something as simple as the return type being string? That is, when the response is evaluated, you end up with the encapsulated string not the json object.

I've been in a similar place myself. I found the options to be either, create a business object that represents the expected jqGrid response and return the object not a string (ASP.NET will serialize it as JSON for you!) or modify the jqGrid to eval the response twice (messy).

Ajw 2009-04-07 01:51:56

Yes! I definitely was missing "rows". Thanks! Unfortunately, I'm not quite out of the woods. FF is now giving me this error:missing ] after element list[Break on this error] ([object Object],[object Object],[object...Object],[object Object],[object Object])

briandus 2009-04-07 04:06:15

Yes! I definitely was missing "rows". Thanks! Unfortunately, I'm not quite out of the woods.

briandus 2009-04-07 04:07:30

It's hard to say from the data that you have posted (I'm noticing some characters that may need to be escaped - htmlencode?). I think your best bet is to simplify the data as much as possible and see if you can get that to fly first.

Ajw 2009-04-07 04:22:24

Answer 4

A:

Yes! I definitely was missing "rows". Thank you so much for helping me finally see that. I've been staring at so many variations of this thing I completely overlooked it! Unfortunately, I'm not quite out of the woods. FF is now giving me this error:

missing ] after element list

[Break on this error] ([object Object],[object Object],[object...Object],[object Object],[object Object])

This error is thrown on this line:

complete: function(data) {
var mygrid = jQuery('table.scroll')[0]; //EVALUATES FINE
var result = (eval("(" + data.responseText + ")"));//EVALUATES FINE
var myjsongrid = (jeval(result.d));//EVALUATES FINE
alert(myjsongrid.rows); //EVALUATES FINE
mygrid.addJSONData(eval("(" + (myjsongrid) + ")")); //THIS BREAKS IT.

Any other suggestions? Again, I'm really appreciative of the help.

briandus 2009-04-07 04:15:38

too late probably - but that has everything to do with your javascript syntax probably missing a } somewhere. try JSLint to validate your syntax

NTulip 2009-06-03 17:46:35

Answer 5

+1 A:

I have spent a lot of time trying to get jqGrid to work with ASP.NET using JSON. Now that I have it working, I would like to share it with you. Hoping to save time for other people.

I found the answer here. This is not to say there are no other ways to make this work (I'm sure there are). But this one definitely works.

To summarize the things that made a difference for me:

Using "datatype: function() {" on the settings of the jqGrid, and NOT using "datatype: json". The function uses "$.ajax(" to call the service. Looking in Fiddler, this changed the data coming back to the browser, to be pure JSON (instead of JSON wrapped in XML).
Using a web service that returns a data class (in the schema jqGrid expects). I first tried using JSON.NET but for some reason the message showed (in Fiddler again) to be escaped with \ for every quote in the string. I'm pretty sure you can get JSON.NET to work. But it works just as well without it.

Ron Harlev 2009-07-23 16:44:07

yes, but with datatype: function() solution, some other functionality starting to behave strange, like loadonce attribute for example..take a look at my question at scfl: http://stackoverflow.com/questions/1329002/jqgrid-loadonce-doesnt-work-with-asp-net

Marko 2009-08-25 15:29:14

ansaurus

tags:

views:

answers:

jqGrid, ASP.NET, JSON is Driving me crazy. Please Help.

related questions