I am using the below function to pass the value selected by the User from the dropdown. I commented the 2nd line in the below code and replaced it with the code suggested by you but still no luck.

There is no search code in the ASP page which pulls the data from database as my assumption is that since the data is written in XML format, then the search will be table bound instead of searching db again.

The below line I have replaced it with $("#list").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: true, defaultSearch:"cn" });

// this function is to show the searchboxes on top of the grid

jQuery("#list").jqGrid('filterToolbar','');

function gridReload()

{

var cd_mask = jQuery("#ProgramName").val();

jQuery("#list").jqGrid('setGridParam',{url:"fetchquestionsdata.asp?prid="+cd_mask+"&q=1",page:1}).trigger("reloadGrid");

}

Appreciate your help

Try this

function gridReload()

{

var cd_mask = jQuery("#ProgramName").val();

return "fetchquestionsdata.asp?prid="+cd_mask+"&q=1″;

}

Regards

I am not able to perform the search activity in the jqGrid. Can someone guide on whether do I need to write a separate SQL query. Currently I am using the below code

$(function(){

$("#list").jqGrid({

url:gridReload(),

datatype: 'xml',

mtype: 'POST',

colNames:['ID','Visible', 'Question Title','Type','Question Hint','Answer','Explanation','File Type', 'File Name'],

colModel :[

//{name: 'myac', width:50, fixed:true, sortable:false, resize:false, formatter:'actions', formatoptions:{keys:true}},

{name:'PK_QuestionTitleID', index:'PK_QuestionTitleID', width:55, sortable:true, align:'center'},

{name:'IsQuestionTitleActive', index:'IsQuestionTitleActive', width:50, sortable:true, align:'center'},

{name:'QuestionTitle', index:'QuestionTitle', width:200, align:'left', sortable:true},

{name:'AnswerOptionType', index:'AnswerOptionType', width:50, align:'center', sortable:true},

{name:'QuestionHint', index:'QuestionHint', width:150, align:'left'},

{name:'CorrectAnswers', index:'CorrectAnswers', width:150, sortable:true},

{name:'CorrectAnswerExplanation', index:'CorrectAnswerExplanation', width:150, sortable:true},

{name:'QuestionFileType', index:'QuestionFileType', width:60, sortable:true, align:'center'},

{name:'QuestionFileName', index:'QuestionFileName', width:120, sortable:false, align:'center'}

],

rowNum:2,

rowList:[10,20,30],

pager: '#pager',

sortname: 'PK_QuestionTitleID',

sortorder: 'asc',

viewrecords: true,

gridview: true,

caption: 'My First grid',

multiselect: false,

subgrid: true,

autowidth: true,

autosearch: true,

height: 300

}).navGrid('#pager',{edit:true,add:true,del:false, search:false})

// this function is to retrieve the value from the Grid

jQuery("#a1").click( function(){

var id = jQuery("#list").jqGrid('getGridParam','selrow');

if (id) {

var ret = jQuery("#list").jqGrid('getRowData',id);

alert("id="+ret.PK_QuestionTitleID+" invdate="+escape(ret.QuestionTitle)+"...");

} else { alert("Please select row");}

});

// this function is to call search box

jQuery("#bsdata").click(function(){

jQuery("#list").jqGrid('searchGrid',

{sopt:['cn','bw','eq','ne','lt','gt','ew']}

);

});

// this function is to show the searchboxes on top of the grid

jQuery("#list").jqGrid('filterToolbar','');

});

function gridReload()

{

var cd_mask = jQuery("#ProgramName").val();

jQuery("#list").jqGrid('setGridParam',{url:"fetchquestionsdata.asp?prid="+cd_mask+"&q=1",page:1}).trigger("reloadGrid");

}