JSON数据在JQGrid中不显示

Question

我曾看过在所有相关的答案中发挥过的建议，但无济于事。我尝试了各种选择，但再次无济于事。我正在使用ASP.NET与C＃作为处理语言，并使用作为数据库引擎的Oracle 10g。

这里是我的.aspx文件：

<form id="LocalizationSearch" name="locSearch" defaultbutton="updateButton" runat="server"> 
    <script language="javascript" type="text/javascript"> 
    jQuery(document).ready(function() { 
     var createLanguageList = function() { 
      $("#list").jqGrid({ 
       url: "KPHandler.ashx?langname=English", 
       datatype: "json", 
       contentType: "application/json; charset=utf-8", 
       mtype: 'POST', 
       //datatype: "local", 
       //data: mydata, 
       autowidth: true, 
       height: 150, 
       colNames: ['DelLanguageID', 'DocRecID', 'LanguageID', 'DocPartNumber,', 'NewLanguage', 'ConcentraIDLang', 'ActFromTranslation'], 
       colModel: [ 
        { name: 'DelLanguageID', index: 'DelLanguageID', width: 65, editable: false }, 
        { name: 'DocRecID', index: 'DocRecID', width: 65, editable: false }, 
        { name: 'LanguageID', index: 'LanguageID', width: 65, editable: false }, 
        { name: 'DocPartNmbr', index: 'DocPartNmbr', width: 65, editable: true }, 
        { name: 'NewLanguage', index: 'NewLanguage', editable: true, edittype: 'checkbox', editoptions: { value: "1:0"} }, 
        { name: 'ConcentraIDLang', index: 'ConcentraIDLang', width: 65, editable: true }, 
        { name: 'ActFromTranslation', index: 'ActFromTranslation', width: 120, editable: true } 
       ], 
       rowNum: 5, 
       rowList: [10, 20, 30], 
       pager: '#pager', 
       sortname: 'DelLanguageID', 
       viewrecords: true, 
       //altRows: true, 
       //sortorder: "desc", 
       caption: "Deliverable Languages", 
       //height: "100%", 
       loadonce: true, 
       gridview: true, 
       autoencode: true, 
       loadError: function (jqXHR, textStatus, errorThrown) { 
        alert('Error: ' + textStatus + errorThrown + jqXHR.responseText); 
       } 
      }); // JQGrid 
     }; // Create function 

     $("#btnLanguages").click(function() { 
      createLanguageList(); 
     }); 

    }); // document ready 

</script> 

    <table cellspacing="1" cellpadding="0" width="100%"> 
     <tr> 
      <td valign="top"> 
       <table id="list"></table> 
       <div id="pager"></div> 
     </td> 
     </tr> 
    </table> 
    <input type="button" id="btnLanguages" value="Work With Languages" /> 

</form> 

，这里是我的C＃代码，构建JSON对象：我

<%@ WebHandler Language="C#" Class="KPHandler" %> 

using System; 
using System.Web; 
using System.Web.Script.Serialization; 
using System.Web.Configuration; 
using System.Text; 
using System.Data; 
using System.Collections.Generic; 
using System.Configuration; 
using System.Data.OracleClient; 

public class KPHandler : IHttpHandler 
{ 
    private DKCL.ReportDK Rpt = new DKCL.ReportDK(); 

    public void ProcessRequest(HttpContext context) 
    { 
     context.Response.ContentType = "application/json"; 
     System.Collections.Specialized.NameValueCollection forms = context.Request.Form; 
     string strOperation = forms.Get("oper"); 

     switch (strOperation) 
     { 
      case null: // means this is the first time load 
       string strSQL = "SELECT DelLanguageID, DocRecID, LanguageID, DocPartNmbr, NewLanguage, " + 
           "ConcentraIDLang, ActFromTranslation FROM DELLANGUAGES WHERE DOCRECID = 18787"; 

       DataTable dlLanguages = Rpt.GetDataTable(strSQL); 

       context.Response.Write(GetJson(dlLanguages)); 

       break; 
      default: 
       break; 
     } // End Switch 

    } 

    // This is generic function that converts DataTable into JSON object. 
    public string GetJson(DataTable dt) 
    { 
     System.Web.Script.Serialization.JavaScriptSerializer serializer = new 

     System.Web.Script.Serialization.JavaScriptSerializer(); 
     List<Dictionary<string, object>> rows = 
      new List<Dictionary<string, object>>(); 
     Dictionary<string, object> row = null; 

     foreach (DataRow dr in dt.Rows) 
     { 
      row = new Dictionary<string, object>(); 
      foreach (DataColumn col in dt.Columns) 
      { 
       row.Add(col.ColumnName.Trim(), dr[col]); 
      } 
      rows.Add(row); 
     } 
     return serializer.Serialize(rows); 
    } 

    public bool IsReusable 
    { 
     get 
     { 
      return false; 
     } 
    } 

} 

，这里是由上面的代码返回的JSON数据（其实得到这个如图Fiddler2），和我自己的调试代码：

  [{"DELLANGUAGEID":"4613","DOCRECID":"18787","LANGUAGEID":"12","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":"c02609839","ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"4614","DOCRECID":"18787","LANGUAGEID":"34","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"4615","DOCRECID":"18787","LANGUAGEID":"1","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":"c02606925","ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"4616","DOCRECID":"18787","LANGUAGEID":"13","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":"c02609850","ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"4617","DOCRECID":"18787","LANGUAGEID":"11","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":"c02606924","ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"4618","DOCRECID":"18787","LANGUAGEID":"3","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":"c02606920","ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"4619","DOCRECID":"18787","LANGUAGEID":"21","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"39703","DOCRECID":"18787","LANGUAGEID":"142","DOCPARTNMBR":"593957-001","NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"89446","DOCRECID":"18787","LANGUAGEID":"161","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"97174","DOCRECID":"18787","LANGUAGEID":"162","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"112630","DOCRECID":"18787","LANGUAGEID":"164","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null},{"DELLANGUAGEID":"104902","DOCRECID":"18787","LANGUAGEID":"163","DOCPARTNMBR":null,"NEWLANGUAGE":0,"CONCENTRAIDLANG":null,"ACTFROMTRANSLATION":null}] 

任何想法，可能是印度*恩错了吗？ 网格显示正确的记录数和页面中的页面。任何帮助将不胜感激。
顺便说一下，我尝试了GET vs POST，json vs jsonstring等以及许多其他选项，包括JSON Reader，但没有运气。

Answer 1

colModel index属性旨在精确反映JSON结果中的键。见documentation：

指数：传递给在其上的数据进行排序的服务器的名称（注意，我们可以通过列数字代替）。通常这是数据库的名字（或名字） - 这是服务器端的排序，所以你传递什么取决于你的服务器希望接收什么。

鉴于此信息，它看起来像您的示例中的索引是不正确的。尝试纠正它们到适当的情况或使用数字值。

例子：

colModel: [{ name: 'DelLanguageID', index: 'DELLANGUAGEID', width: 65, editable: false },... 

Answer 2

谢谢边条。这对我来说很痛苦，但颇具教育意义。现在只需更改** ColModel **即可使用。再次感谢。