Client side pagination is not working in jqGrid
-
Hi Friends, I am new user for jQuery and jqGrid. I am trying to implement jqGrid with client side pagination. It is not working at my end. I am using .net 4.0 web service to get json respons. This is my web service code
public string GetMessage(string FDate,string TDate,string Status)
{
databaseDataContext dc = new databaseDataContext();
var v = (from v1 in dc.WBS_MESSAGEs
where v1.TransStatus == Status && v1.CreatedDate >= fromDate
&& v1.CreatedDate <= toDate
select new
{
v1.MessageID,
v1.Task,
v1.Remark,
v1.CreatedDate,
Object = (v1.ObjectID == "2" ? "Business Partner" :
v1.ObjectID == "30" ? "Journals" : "Unknown")
});
if (v.Count() > 0)
{System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); return js.Serialize(v.ToList()); } else { return null; } }This is my JavaScript / jqGrid code
function callMessage(p0, p1,p2,ctrlName) { $.ajax({ type: "POST", url: "SAPBOne.asmx/GetMessage", data: '{ "FDate":"' + p0 + '" ,"TDate":"' + p1 + '","Status":"' + p2 + '"}', contentType: "application/json; charset=utf-8", dataType: "json", error: function (data) { alert(data.statusText); }, success: function (data) { var thegrid = jQuery(ctrlName)[0]; thegrid.addJSONData(JSON.parse(data.d)); // var jSonMessage = JSON.parse(data.d); // data.d is a JSON formatted string, to turn it into a JSON object // we use JSON.parse // now that myData is a JSON object we can access its properties like normal } }); }; $(window).load(function () { var qString = get_qu -
Hi Friends, I am new user for jQuery and jqGrid. I am trying to implement jqGrid with client side pagination. It is not working at my end. I am using .net 4.0 web service to get json respons. This is my web service code
public string GetMessage(string FDate,string TDate,string Status)
{
databaseDataContext dc = new databaseDataContext();
var v = (from v1 in dc.WBS_MESSAGEs
where v1.TransStatus == Status && v1.CreatedDate >= fromDate
&& v1.CreatedDate <= toDate
select new
{
v1.MessageID,
v1.Task,
v1.Remark,
v1.CreatedDate,
Object = (v1.ObjectID == "2" ? "Business Partner" :
v1.ObjectID == "30" ? "Journals" : "Unknown")
});
if (v.Count() > 0)
{System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); return js.Serialize(v.ToList()); } else { return null; } }This is my JavaScript / jqGrid code
function callMessage(p0, p1,p2,ctrlName) { $.ajax({ type: "POST", url: "SAPBOne.asmx/GetMessage", data: '{ "FDate":"' + p0 + '" ,"TDate":"' + p1 + '","Status":"' + p2 + '"}', contentType: "application/json; charset=utf-8", dataType: "json", error: function (data) { alert(data.statusText); }, success: function (data) { var thegrid = jQuery(ctrlName)[0]; thegrid.addJSONData(JSON.parse(data.d)); // var jSonMessage = JSON.parse(data.d); // data.d is a JSON formatted string, to turn it into a JSON object // we use JSON.parse // now that myData is a JSON object we can access its properties like normal } }); }; $(window).load(function () { var qString = get_quHere is a good thread about this topic ;) http://stackoverflow.com/questions/3197065/jqgrid-on-clientside-paging-editing-sorting-queries[^]
Light or darkness, we must choose ...