Like promised you code example in UPDATED parts of http://stackoverflow.com/quest.....42#3161542.

I hope it will solve all your problem.

Best regards
Oleg 

jQuery("#list").jqGrid({

datatype: processrequest,

mtype: 'POST',

jsonReader: {

root: "rows", //arry containing actual data

page: "page", //current page

total: "total", //total pages for the query

records: "records", //total number of records

repeatitems: false,

id: "ID" //index of the column with the PK in it

},

colNames: ['Name', 'Title'],

colModel: [

{ name: 'name', index: 'name', width: 250 },

{ name: 'title', index: 'title', width: 250 }

],

pager: '#pager',

rowNum: 10,

rowList: [10, 20, 30],

sortorder: "desc",

viewrecords: true,

height: '250px',

caption: 'My first grid'

}).navGrid('#pager', {edit: false, add: false, del: false});

});

function processrequest(postdata) {

// alert(postdata._search);

// alert(postdata.searchString);

$(".loading").show();

$.ajax({

type: "POST",

data: "{}",

datatype: "json",

url: "../webServices/myTestWS.asmx/testMethod",

contentType: "application/json; charset-utf-8″,

complete: function (jsondata, stat) {

if (stat == "success") {

var thegrid = jQuery("#list")[0];

var jsonObject = (eval("(" + jsondata.responseText + ")"));

thegrid.addJSONData(jsonObject.d);

$(".loading").hide();

} else {

$(".loading").hide();

alert("Error with AJAX callback");

}

}

});

}

My scenario was very simple as I wanted to see how it worked in the easiest form before I ramped it up into something more complicated.  

First my object that my webservice returned had to have the following properties (or some variation):

Private _total As Integer

Private _records As Integer

Private _page As Integer

Private _rows As List(of names)

The second key was my webservice.  I added the following to my ASP.Net webservice:

<ScriptMethod(ResponseFormat:=ResponseFormat.Json)> _

<WebMethod()> _

The JSON data that was returned finally looked correct:

{"d":{"__type":"myJQueryTestBed.myTest",

"total":2,"records":2,"page":1,

"rows":[{"name":"Jeff","title":"Programmer"},{"name":"Steve","title":"Programmer"}]}}

Lastly my jQuery code needed the following:

jsonReader: {

root: "rows", //arry containing actual data

page: "page", //current page

total: "total", //total pages for the query

records: "records", //total number of records

repeatitems: false,

id: "ID" //index of the column with the PK in it

},

To be honest I'm still trying to figure this part out for the paging functionality but this is what worked for me in my VERY simple code example.

Also this is my call using the addJSONData:

var thegrid = jQuery("#list")[0];

var jsonObject = (eval("(" + jsondata.responseText + ")"));

thegrid.addJSONData(jsonObject.d);

If you need all the code to get this very simple example to work message me and I will copy everything for you.  I can guarantee that ASP.NET and jqGrid does work.  There are just a couple of flaming hoops you have to jump through to get there initially.  I will say that it was really easy to ramp up my code to a much more complicated set of data once I had figured out this simple example.

I think that you need to set dataType to "json" (rather than "local") in your ajax call.

Other than that, perhaps the url ...

../webServices/myTestWS.asmx/testMethod

... is incorrect (ie. using ../ at the front might not be finding it correctly).  I hope that helps

Cheers,

Michael

I've been battling this problem for a few weeks now.  I still haven't resolved the problem at hand and have tried just about everything I can think of. If you get this working please let me know how you did so and if I determine the issue I'll let you know asap.

Nathan

{"d":"name: Jeff V title: Programmer"}

I want to load the grid using this JSON data.

I have tried many different ways and examples to load this 
into the grid but I have had 0 luck.
Here is my code:

jQuery(document).ready(function () {
jQuery("#list").jqGrid({
datatype: processrequest,
mtype: 'POST',
colNames: ['Name', 'Title'],
colModel: [
{ name: 'name', index: 'name', width: 55 },
{ name: 'title', index: 'title', width: 90 }
],
pager: jQuery('#pager'),
rowNum: 10,
rowList: [10, 20, 30],
sortname: 'id',
sortorder: "desc",
viewrecords: true,
imgpath: 'themes/basic/images',
caption: 'My first grid'
});
});




function processrequest(postdata) {
$(".loading").show();
$.ajax({
type: "POST",
data: "{}",
dataType: "local",
url: "../webServices/myTestWS.asmx/testMethod",
contentType: "application/json; charset-utf-8",
complete: function (jsondata, stat) {
if (stat == "success") {
var thegrid = jQuery("#list")[0];
thegrid.addJSONData(eval("(" + jsondata.responseText + ").d"));
$(".loading").hide();
} else {
$(".loading").hide();
alert("Error with AJAX callback");
}
}
});
}


Any help is appreciated!  Thanks

]]>
        	        	Wed, 30 Jun 2010 18:21:16 +0300