codice:
$(document).ready(function(){
$("#list").jqGrid
({
url:'carica_modelli.asp',
datatype: 'xml',
mtype: 'GET',
colNames:["descrizione auto","modello","targa","pk_auto"],
prmNames: {id: "pk_auto"},
colModel :[
{name:'descrizione_azione',index:'descrizione_azione',editable:true,editoptions:{readonly:true},reloadAfterSubmit: true ,width:300,edittype:"select", editoptions:{dataUrl:'select_auto.asp'}},
{name:'modello', editable:true,editoptions: {rows:"2",cols:"30"},reloadAfterSubmit: true,index:'modello',width:300, reloadAfterSubmit: true,closeAfterAdd:true,reloadAfterSubmit:true},
{name:'targa', editable:true,reloadAfterSubmit: true,index:'targa',width:300, reloadAfterSubmit: true,closeAfterAdd:true,reloadAfterSubmit:true},
{name:'pk_auto',hidden: true , editable: true, editrules: {edithidden:true} ,reloadAfterSubmit: true,index:'pk_auto',width:50, reloadAfterSubmit: true,closeAfterAdd:true,reloadAfterSubmit:true,editrules:{number:true}}
],
height:'auto',
rowNum:5000,
pager : '#pagerA',
viewrecords: false,
imgpath: 'css/ui-lightness/images',
loadonce: false,
xmlReader: {
root : "NewDataSet",
row: "Table",
repeatitems: false,
id: "pk_auto"
},
sortorder: "pk_auto",
caption:'Auto',
editurl:'edit.asp'
});
jQuery(list).jqGrid('navGrid','#pagerA',{edit:true,add:true,del:true,search:false,refresh:false} ,
{mtype:"POST", reloadAfterSubmit:true, serializeDelData: function (postdata) {
var rowdata = jQuery("#list").getRowData(postdata.id);
// append postdata with any information
return {id: postdata.id, oper: postdata.oper, user_id: rowdata.user_id};
}} //
);
$('#pagerA_center').empty();
});
Come detto, 'select_auto.asp' richiama una stored procedure per generare l'elenco.