Populating JQGrid with C# JSON

Posted on 2011-09-26
Medium Priority
Last Modified: 2012-05-12

I have been trying to populate a JQGrid using JSON created by a C# webservice.  It is coming back with a status of "success", but no data is appearing in the grid.  Below is the data which is being returned from the webservice.  Is there something wrong with the format here?

{"total": "5","page": "1","records": "5","rows":[{"id":"1","cell":["1","user1","dublin","first user","","17/01/2011 21:37:08"]},
{"id":"2","cell":["2","Administrator","dublin","administrator","15/04/2011 14:15:08","18/02/2011 20:55:24"]}, {"id":"3","cell":["3","user 2","dublin","","13/05/2011 15:18:47","13/05/2011 10:52:03"]}, {"id":"4","cell":["4","user 3","dublin","third user","23/06/2011 17:59:06","15/06/2011 13:51:35"]}, {"id":"5","cell":["5","user 4","dublin","fourth user","","09/08/2010 08:53:49"]} ]}

The JQuery to populate the grid is:
<script language="javascript" type="text/javascript">
       jQuery(document).ready(function () {
               datatype: function () {
                       url: "/webservices/activedirectory.asmx/GetActiveDirectoryUsersJson",
                       data: '{"GroupName":"test","Filter":""}',
                       dataType: "json",
                       type: "POST",
                       contentType: "application/json; charset=utf-8",
                       complete: function (jsondata, stat) {
                           if (stat == "success") {
                               var thegrid = jQuery("#list2")[0];
               colNames: ['ID', 'LogonName', 'DomainName', 'Description', 'Last Logon', 'Days Since PW Changed'],
               colModel: [
                            { name: 'id', index: 'id asc', width: 155 },
                            { name: 'LogonName', index: 'logonname asc', width: 155 },
                            { name: 'DomainName', index: 'domainname', width: 150 },
                            { name: 'Description', index: 'description', width: 200 },
                            { name: 'LastLogon', index: 'lastlogon', width: 80, align: "right" },
                            { name: 'pwdlastset', index: 'pwdlastset', width: 180, align: "right"}],
               rowNum: 15,
               rowList: [15, 30, 100],
               pager: jQuery('#pager2'),
               sortname: 'logonname',
               loadtext: "loading data...",
               viewrecords: true,
               sortorder: "desc",
               jsonReader: {
                   root: "d",
                   page: function () { return 1; },
                   total: function () { return 1; },
                   records: function (obj) { return obj.length; }


Open in new window

Many thanks
Question by:itfocus
LVL 83

Accepted Solution

leakim971 earned 500 total points
ID: 36600432
column names are not the same

Author Closing Comment

ID: 36998669
Oops; I didn't spot that at the time.  Thanks

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction HyperText Transfer Protocol (http://www.ietf.org/rfc/rfc2616.txt) or "HTTP" is the underpinning of internet communication.  As a teacher of web development I have heard many questions, mostly from my younger students who have come to t…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question