Hi ALL,
I’m using jqGrid in ASP.NET. jqGrid is literally good. As of now, I’m
using Handler(ashx) through WebService(asmx) to convert the DataTable into
JSON and display in the Grid.
I m Unable to Populate the data to jqgrid. I m getting the data from database to generichandlers page. But That data is not bind to grid .I m getting the Following Error on Jqgrid. I m unable to Solve it. The Error is look like this
Line:13
Char:149
Error: Expected ']'
Code '0'
My Code is look like this. pls tell the mistake
function GetMemberslist()
{
jQuery("#addgrid").jqGrid({
url: "Membership.ashx",
datatype:'json',
height: 400,
width:800,
colNames: ['Campus', 'Enrollno/EmpNo','Name','Issuedate','Expirydate','Address','Type','Amount'],
colModel: [
{ name: 'campus', index: 'campus', width: 100,align: 'center', editable: false, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'enrollno', index: 'enrollno', width: 100, align: 'left', editable: true, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'Name', index: 'Name', align: 'left',width: 100, editable: true, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'issuedate', index: 'issuedate', width: 100, align: 'left', editable: true, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'expirydate', index: 'expirydate', width: 100, align: 'left', editable: true, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'Address', index: 'Address', width: 100, align: 'left', editable: true, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'Type', index: 'Type', width: 100, align: 'left', editable: true, editoptions: { size: 10 }, editrules: { required: true} },
{ name: 'Amount', index: 'Amount',width: 100, align: 'left', editable: true, editoptions: { size: 10 }, editrules: { required: true} }
],
rowNum: 10,
rowList: [5, 10, 20, 50],
sortname: 'enrollno',
pager: jQuery('#pagerad'),
sortorder: "asc",
caption: "MemberShip Details",
editurl: "" ,
height:210
}).navGrid('#pagerad',
{edit:false,add:false,search:false,del:false}, //options
{height:300,reloadAfterSubmit: true }, // edit options
{height:300,reloadAfterSubmit: true }, // add options
{
//reloadAfterSubmit: true,url: "WebService.asmx/Delete" + a
// reloadAfterSubmit: true,url: "Services/LibService.asmx/Deletemembership"
}, // del options
{} // search options
);
$("#update").click(function(){
var gr = jQuery("#addgrid").getGridParam('selrow');
if( gr != null ){
//jQuery("#addgrid").editGridRow(gr,{height:280,reloadAfterSubmit:false});
var ret = $("#addgrid").getRowData(gr);
//GetNewsItem(ret.ID);
// alert(ret.enrollno);
ItemMouseClickmember(ret.enrollno)
}
else {
alert("Please Select Row");
}
});
$("#delete").click(function(){
var gr = jQuery("#addgrid").getGridParam('selrow');
if( gr != null ){
//jQuery("#addgrid").editGridRow(gr,{height:280,reloadAfterSubmit:false});
var ret = $("#addgrid").getRowData(gr);
// ItemDelete(ret.ID);
//alert(ret.ID);
ItemMouseClickmemberDelete(ret.enrollno);
}
else {
alert("Please Select Row");
}
});
}