[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Populating JQGrid with C# JSON

Posted on 2011-09-26
2
Medium Priority
?
1,965 Views
Last Modified: 2012-05-12
Hi,

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 () {
           jQuery("#list2").jqGrid({
               datatype: function () {
                   $.ajax({
                       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];
                               alert(JSON.parse(jsondata.responseText).d);
                               thegrid.addJSONData(JSON.parse(jsondata.responseText).d);
                           }
                       }
                   });
               },
               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; }
               }
           });

       });
               </script>

Open in new window


Many thanks
0
Comment
Question by:itfocus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 82

Accepted Solution

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

Author Closing Comment

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

jQuery is a JavaScript library that greatly simplifies JavaScript programming. AJAX is an acronym formed from "Asynchronous JavaScript and XML."  AJAX refers to any communication between client and server, when the human client does not observe a…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

656 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