jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

Okay I give in - can you please help? ASP ->Json->JQgrid=no grid

Tags: json jqgrid problem asp ajax problems

22/04/2010
22:37

famousde

USA

New Member

Members

Forum Posts: 2

Member Since:
22/04/2010

Offline

Hi there,

I have been trying everthing I can think of, twice, and cannot get thie grid to rendure from the json I am sending. I am out of ideas and am hoping someone could offer a solution or suggestion.

Client script:

$(document).ready(function() {
jQuery("#jsonmap").jqGrid({ url:'ajaxadmindatasource.asp', datatype: "json", colNames:['personId','firstname', 'lastname', 'email','membershipType','primaryCommittee'],
colModel:[
{name:'personId',index:'personId', width:55},
{name:'firstname',index:'firstname', width:90},
{name:'lastname',index:'lastname', width:100},
{name:'email',index:'email', width:80, align:"right"},
{name:'membershipType',index:'membershipType', width:80, align:"right"},
{name:'primaryCommittee',index:'primaryCommittee', width:80,align:"right"}
],
rowNum:10, rowList:[10,20,30], pager: '#pjmap', sortname: 'personId', viewrecords: true, sortorder: "desc", jsonReader: { repeatitems : false, id: "0" }, caption: "JSON Mapping", height: '100%' }); jQuery("#jsonmap").jqGrid('navGrid','#pjmap',{edit:false,add:false,del:false});
})

Ajax server response in Json format:

[{"personId":1237,"firstname":"Oscar","lastName":"Franco","email":"ofranco@rcfbh.org","membershipType"

:null,"primaryCommittee":null},{"personId":1236,"firstname":"Rosalina","lastName":"Baldonado","email"

:"rosalina29m5@hotmail.com","membershipType":null,"primaryCommittee":null}
,{"personId":1235,"firstname"

:"David","lastName":"Modeer","email":"dmodeer@cap-az.com","membershipType":"Partner","primaryCommittee"

:"Water"},{"personId":1234,"firstname":"Armando","lastName":"Contreras","email":"Armandoc@azhcc.com"

,"membershipType":"Individual Membership","primaryCommittee":"Economic Development"}
,{"personId":1233

,"firstname":"Lea","lastName":"Marquez Peterson","email":"president@tucsonhispanicchamber.org","membershipType"

:null,"primaryCommittee":null},{"personId":1232,"firstname":"Edward","lastName":"Drusina","email":"edward

.drusina@usibwc.gov","membershipType":null,"primaryCommittee":null}
,{"personId":1231,"firstname":"BEVERLY"

,"lastName":"DE WAARD","email":"beverly9915@att.net","membershipType":null,"primaryCommittee":null},

{"personId":1230,"firstname":"David","lastName":"Farca","email":"david@ToHStudio.com","membershipType"

:null,"primaryCommittee":null}
,{"personId":1229,"firstname":"Haru","lastName":"Yamasaki","email":"hyamasaki

@fumec.org","membershipType":"Individual Membership","primaryCommittee":"Economic Development"}
,{"personId"

:1228,"firstname":"Mike","lastName":"Morgan","email":"Mike@PinnacleAerospace.com","membershipType":"Individual

Membership","primaryCommittee":"Economic Development"}]

I get one error message: b.jgrid.formatter is undefined

thank you in advanced for any input and assistance you can give.

Thanks

Dave

23/04/2010
05:59

famousde

USA

New Member

Members

Forum Posts: 2

Member Since:
22/04/2010

Offline

Hi everybody,

I finally got this working so please disregard
this help request.

Thankss

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
29 Guest(s)

Currently Browsing this Page:
1 Guest(s)