dineshsharmain on Data Loading issue while calling serverside method

Tue, 21 Jun 2011 19:26:32 +0300

Below is my JQuery code, I want to make a server call like simple jquery post method but it doesn't call server methods

JQuery Code -

jQuery("#jqgajax").jqGrid({

ajaxGridOptions: { type: "POST" },

serializeGridData: function (postdata) {

postdata.page = 1;

return postdata;

contentType: "application/json; charset=utf-8",

url: "gridData.aspx/GetData",

datatype: "json",

colNames: ['Part Id', 'Part Number', 'Description', 'Part Category', 'LOB Id'],

colModel: [

{ name: 'PartId', index: 'PartId', width: 55 },

{ name: 'PartNumber', index: 'PartNumber', width: 90 },

{ name: 'PartDescription', index: 'PartDescription asc', width: 100 },

{ name: 'PartCategoryId', index: 'PartCategoryId', width: 80, align: "right" },

{ name: 'LOBId', index: 'LOBId', width: 80, align: "right" }

rowNum: 10,

width: 700,

rowList: [10, 20, 30],

pager: '#pjqgajax',

sortname: 'PartNumber',

viewrecords: true,

sortorder: "desc",

caption: "Parts Details"

});

jQuery("#pjqgajax").jqGrid('navGrid','#pjqgajax',{edit:false,add:false,del:false});

C# Code(File Name 'gridData.aspx') – Not being called

[WebMethod]

public static string GetData()

{

// Create a new Sql Connection and set connection string accordingly

SqlConnection sqlConnection = new SqlConnection();

sqlConnection.ConnectionString = "initial catalog=kaizen;data source=.;uid=realm;integrated security=SSPI";

sqlConnection.Open();

string sqlStatement = "select PartId, PartNumber, PartDescription, PartCategoryId, LOBId from partsdetails";

SqlCommand cmd = new SqlCommand(sqlStatement, sqlConnection);

DataTable dtResult = new DataTable();

SqlDataAdapter adp=new SqlDataAdapter(cmd);

adp.Fill(dtResult);

return GetJSONString(dtResult);

}

jQuery Grid Plugin - jqGrid - Topic: Data Loading issue while calling serverside method