Guriddo » Topic: search in jqgrid

search in jqgrid

Guriddo
search in jqgrid

This topic has 1 reply, 2 voices, and was last updated 13 years, 9 months ago by tony.

Creator

Topic

September 7, 2012 at 1:30 pm #80296

M-B

Participant

i'm starter in jqgrid, i write this code for build jqgrid in asp.net

<div class="sfcode">var grid = $(&#39;#list&#39;);<br />
grid.jqGrid({<br />
url: &#39;jQGridHandler.ashx&#39;,<br />
postData: { ActionPage: &#39;CostTypes&#39;, Action: &#39;Fill&#39; },<br />
ajaxGridOptions: { cache: false },<br />
direction: "rtl",<br />
<br />
datatype: &#39;json&#39;,<br />
<br />
height: 490,<br />
colNames: [&#39;CostId&#39;, &#39;CostNo&#39;, &#39;CostName&#39;, &#39;Remark &#39;],<br />
colModel: [<br />
{ name: &#39;COST_ID&#39;, width: 100, sortable: true, search:true, editable: false, hidden: true, key: true, index: &#39;COST_ID&#39; },<br />
{ name: &#39;COST_NO&#39;, width: 100, sortable: true, editable: true },<br />
{ name: &#39;COST_NAME&#39;, width: 350, sortable: true, editable: true },<br />
{ name: &#39;REMARK&#39;, width: 300, sortable: true, editable: true }<br />
<br />
],<br />
gridview: true,<br />
rowNum: 30,<br />
rowList: [30, 60, 90],<br />
pager: &#39;#pager&#39;,<br />
sortname: &#39;COST_ID&#39;,<br />
viewrecords: true,<br />
rownumbers: true<br />
});<br />
grid.jqGrid(&#39;navGrid&#39;, &#39;#pager&#39;, { add: false, edit: false, del: true, search: true },<br />
{},<br />
{},<br />
{ url: "JQGridHandler.ashx?ActionPage=CostTypes&#038;Action=Delete", reloadAfterSubmit: false },<br />
{ multipleSearch: true});<br /></div><p>when click in search icon and show search box when enter text example <code>costNo=1</code> jqGrid not filter i think this action no work, please help me for implimet search in jqgrid</p><br />
<p>EDIT 01: when i add <code>loadonce: true</code> search work but when remove this option search don&#39;t work, please help me. thanks</p>

<div class="sfcode">var grid = $('#list');

grid.jqGrid({

url: 'jQGridHandler.ashx',

postData: { ActionPage: 'CostTypes', Action: 'Fill' },

ajaxGridOptions: { cache: false },

direction: "rtl",

datatype: 'json',

height: 490,

colNames: ['CostId', 'CostNo', 'CostName', 'Remark '],

colModel: [

{ name: 'COST_ID', width: 100, sortable: true, search:true, editable: false, hidden: true, key: true, index: 'COST_ID' },

{ name: 'COST_NO', width: 100, sortable: true, editable: true },

{ name: 'COST_NAME', width: 350, sortable: true, editable: true },

{ name: 'REMARK', width: 300, sortable: true, editable: true }

],

gridview: true,

rowNum: 30,

rowList: [30, 60, 90],

pager: '#pager',

sortname: 'COST_ID',

viewrecords: true,

rownumbers: true

});

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

{},

{ url: "JQGridHandler.ashx?ActionPage=CostTypes&Action=Delete", reloadAfterSubmit: false },

{ multipleSearch: true}); </div>when click in search icon and show search box when enter text example <code>costNo=1</code> jqGrid not filter i think this action no work, please help me for implimet search in jqgrid

EDIT 01: when i add <code>loadonce: true</code> search work but when remove this option search don't work, please help me. thanks

Creator

Topic

Viewing 1 replies (of 1 total)

Author

Replies
September 10, 2012 at 6:54 pm #100156

tony
Keymaster

Hello,

yYou will need to understand that the grid does not support a search at your end (server)

You will need to write your own code at server to perform the search.

We have a examples in PHP, but you can easy understand and translet it in ASP.

Also you may need to look at the demo files which can be downloaded from the Download section.

Regards
Author

Replies