How to work with jqGrid

Loading data

This example show how we can load array data. In this case we use a addRowData method

HTML



Java Scrpt code

<br /> jQuery("#list4").jqGrid({<br /> datatype: "local",<br /> height: 250,<br /> colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],<br /> colModel:[<br /> {name:'id',index:'id', width:60, sorttype:"int"},<br /> {name:'invdate',index:'invdate', width:90, sorttype:"date"},<br /> {name:'name',index:'name', width:100},<br /> {name:'amount',index:'amount', width:80, align:"right",sorttype:"float"},<br /> {name:'tax',index:'tax', width:80, align:"right",sorttype:"float"}, <br /> {name:'total',index:'total', width:80,align:"right",sorttype:"float"}, <br /> {name:'note',index:'note', width:150, sortable:false} <br /> ],<br /> imgpath: gridimgpath,<br /> multiselect: true,<br /> caption: "Manipulating Array Data"<br /> });<br /> var mydata = [<br /> {id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},<br /> {id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},<br /> {id:"3",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},<br /> {id:"4",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},<br /> {id:"5",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},<br /> {id:"6",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},<br /> {id:"7",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},<br /> {id:"8",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},<br /> {id:"9",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}<br /> ];<br /> for(var i=0;i&amp;lt;=mydata.length;i++)<br /> jQuery("#list4").addRowData(i+1,mydata[i]);<br />

list4 is table id