ASP.NET

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;
            }
    }

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_query();
                //Get Success Messages
                jQuery("#jsonmap").jqGrid({
                    url: callMessage(qString.p0, qString.p1,'Success','#jsonmap'),
                    datatype: 'json',
                    colNames: ['Message ID', 'Object', 'Task', "CreatedDate", 'Remark'],
                    ajaxGridOptions: { contentType: 'application/json; charset=utf-8' },
                    colModel: [
                                    { name: 'MessageID', index: 'MessageID asc', sortable: true, align: "center", width: 55 },
                                    { name: 'Object', index: 'Object', width: 120, jsonmap: "Object" },
                                    { name: 'Task', index: 'Task', width: 80, jsonmap: "Task", align: "center" },
                                    { name: 'CreatedDate', index: 'CreatedDate', jsonmap: "CreatedDate", align: "center", formatter: 'date', formatoptions: { srcformat: 'yyyyMMdd', newformat: 'd-M-y @ H:i:s' }, width: 140 },
                                    { name: 'Remark', index: 'Remark', width: 300, jsonmap: "Remark" }
                                ],
                    serializeGridData: function (postData) {
                        return JSON.stringify(postData);
                    },
                    loadtext: "Loading...",
                    rowNum:5,
                    rowList: [5, 10],
                    pager: '#pjmap',
                    sortname: 'MessageID',
                    sortorder: "desc",
                    viewrecords: true,
                    gridview: true,
                    loadonce:true,
                    sortorder: "desc",
                    sortname: 'MessageID',
                    caption: "Success",
                    pgbuttons: true,
                    height: 'auto',
                    refreshtext:'Refresh',
                    repeatitems: true,
                    emptyrecords: "No records to view"
                });
                jQuery("#jsonmap").jqGrid('navGrid', '#pjmap', { edit: false, add: false, del: false  });