using jqGrid as a kind of results display mechanism RSS

• • Reply
  

  DmainEvent

  Member

  86 Points

  129 Posts

  using jqGrid as a kind of results display mechanism

  Jun 09, 2012 02:25 PM|LINK

  Kind of a generic title, so let me get into it a little bit.  I am trying to implement an asynchronous search function on my website (You search for something and the results return to you on the same page)... The return result will be displayed in grid format using jqGrid.  I have a submit form all ready to rock and roll... My jqGrid is ready and rearing to go...  I am going to be using a datatype of JsonString...  So the jqGrid will not be hooked directly into a database or anything like that...  I basically hit a webservice and the results come back... I need to jSonify the results in a propper manner...  And that might be a point of failure right now...  But I am wondering if what I am trying to do is e even possible with jqGrid?  
  
  And if it is possible I am also wondering if I am going about it in the right way?

  "{\"total\":1,\"page\":1,\"records\":1,\"rows\":[{\"cell\":[\"\",\"342352857634\",\"test\",\"test\",\"5/8/2012 11:39:38 AM\",\"1\",\"\",\"1/1/0001 12:00:00 AM\",\"1/1/0001 12:00:00 AM\",\"1/1/0001 12:00:00 AM\"]}]}"

  this is the function that does all of the Magic.

  $('#SearchPatID').submit(function (event) {
          //alert("What the is going on here!");
          debugger;
          var theURL = this.action;
          var type = this.methd;
          event.preventDefault();
          $.ajax({
              url: this.action,
              type: this.method,
              data: $(this).serialize(),
              dataType: "json",
              success: function (result) {
                  debugger;
                  bindData(result);
              }
          });
          return false;
      });
      var bindData = function (result) {
          //debugger;
          alert('Glad this is kind-of working!');
          $("#list").jqGrid({
              //url: $("#DisplayUniqueEncounters").attr("action"), //'/Home/GridData/',
              gridview: false,
              shrinkToFit: false,
              autowidth: true,
              datatype: 'json',
              datastr: result,
              mtype: 'POST',
              colNames: [//'Edit',
                         'MRN',
                         'Hospital Fin',
                         'First Name',
                         'Last Name',
                         'Date of birth',
                         'Completed Pathway',
                         'Completed Pathway Reason',
                         'PCP Appointment',
                         'Specialist Appointment',
                         'Admit Date'
                         ],
              colModel: [
                         //{ name: 'Edit', width: 95, align: 'left' },
                         { name: 'MRN', width: 125, align: 'left' },
                         { name: 'Hospital_Fin', width: 145, align: 'left' },
                         { name: 'First_Name', width: 115, align: 'left' },
                         { name: 'Last_Name', width: 115, align: 'left' },
                         { name: 'Date_of_birth', width: 145, align: 'left' },
                         { name: 'Completed_Pathway', width: 125, align: 'left' },
                         { name: 'Completed_Pathway_Reason', width: 165, align: 'left' },
                         { name: 'PCP_Appointment', width: 115, align: 'left' },
                         { name: 'Specialist_Appointment', width: 125, align: 'left' },
                         { name: 'Admit_Date', width: 185, align: 'left' }
                         ],
              //pager: jQuery('#pager'),
              rowNum: 10,
              rowList: [5, 10, 20, 50],
              sortname: 'Id',
              sortorder: "desc",
              viewrecords: true,
              imgpath: '/scripts/themes/coffee/images',
              caption: 'My first grid'
          });
      }
  

  What Am I missing? I have my Json data, everything should be working out fine right?

  I realized I was sending in a JSON string and not necesarrily a JSON object... so I changed the datatype to jsonstring from json... still doesn't work.

  Here is what returns my JSON data

  public static string JsonHelper(TemplateModel model){
  
          var values = model.Template;
          var JsonDataList = new {
              total = 1,
              page = 1,
              records = model.Template.Count,
              rows = (from val in values
                      select new {
                          invdata = new string[]{
                              "MRN"+val.MRN,
                              "Hospital_Fin"+val.HostpitalFinNumber,
                              "First_Name"+val.FirstName,
                              "Last_Name"+val.LastName,
                              "Date_of_birth"+val.DateOfBirth.ToString(),
                              "Completed_Pathway"+val.CompletedPathway,
                              "Completed_Pathway_Reason"+val.CompletedPathwayReason,
                              "PCP_Appointment"+val.PCPAppointmentDateTime.ToString(),
                              "Specialist_Appointment"+val.SpecialistAppointmentDateTime.ToString(),
                              "Admit_Date"+val.AdminDate.ToString()
                          }
                      }).ToArray()
          };
          return JsonConvert.SerializeObject(JsonDataList);
      }
  

  plus...

  return Json(DataRepository.JsonHelper(model.FirstOrDefault()), JsonRequestBehavior.AllowGet);

  What Am I doing wrong? I will try not setting up the jqGrid, and then loading it on submit... But I would like to be able to load this thing on every submit that occurs.

  I also want to put MVC action links in there eventually. Or at least make each row be a link to an action... Ill have to figure out how that can be done using JsonString data type... But I guess I will cross that bridge when I get there.

  Also, this editor is terrible, I am having a hard time figuring out how to differentiate code sections from regular paragraph sections. ANy idea how to get that done?

• • Reply
  

  sushanth009

  Contributor

  6243 Points

  1168 Posts

  Re: using jqGrid as a kind of results display mechanism

  Aug 08, 2012 10:13 PM|LINK

  I suggest you post the questions related to jqgrid in the forum dedicated to this plugin where you can find more help..

  http://www.trirand.com/blog/?page_id=393/

  http://forum.jquery.com/using-jquery-plugins