jQuery Grid Plugin - jqGrid - Topic: Save changes in DB using Sortablerows http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows Simple:Press Version 5.7.5.3 tony on Save changes in DB using Sortablerows http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30728 Help http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30728 Hello,

As far as I understand you will need to use this in the update event in sortable rows, so that you get the new order and send it to the server - as far as I understand the requierment.

Kind Regards

]]> Fri, 06 Jun 2014 12:08:56 +0300 Bourne on Save changes in DB using Sortablerows http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30716 Help http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30716 thanks for your answer Tony

i need use getDataIDs before or after Update?

i'm newbie in javascript :(

]]> Mon, 02 Jun 2014 19:36:10 +0300 tony on Save changes in DB using Sortablerows http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30713 Help http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30713 Hello,

In the update event you define you can get the new order of the id.
To get the new ids you can use getDataIDs grid method.

Kind Regards

]]> Mon, 02 Jun 2014 17:11:10 +0300 Bourne on Save changes in DB using Sortablerows http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30705 Help http://www.trirand.com/blog/?page_id=393/help/save-changes-in-db-using-sortablerows#p30705 Hello guys, im starting in javascript world and need your help

i'm using jqgrid to get data from my server, this data now in my grid and usind sortablerows to move the rows, the problem is that i need save new order in the DB.

i need save the info using get submit.

Ex. urlService +"guardarCambios?callback=?"

urlService: url where is my webservice

guardarCambios?callback=? here call my method to send data, my code is this.

$(function(){

jQuery("#list").jqGrid({
url: urlService+"llamarDatos?callback=?",
postData:{Programa:programa},
datatype: "json",
mtype: "GET",
colNames: ['Orden','Nombre','Posición','Tipo' ,'','<input name="guardar" type="image" src="Resources/bt_mas.png" onclick=nuevapromocion(); width=20 height=20/>'],
colModel: [ { name:'orden', index: 'orden',sortable:false, width: 30 ,resizable:true, hidden:false},
{ name:'nombre', index: 'nombre',sortable:false, width: 100 ,resizable:true},
{ name:'posicion', index: 'posicion',sortable:false, width: 100 ,resizable:true},
{ name:'tipo', index: 'tipo',sortable:false, width: 70 ,resizable:false},
{ name:'Action',width: 30, sortable: false, classes: 'action', align: 'center',resizable:false},
{ name:'Action2',width:30,align:'center',resizable:false,sortable:false,},
],
rowNum: 10,
loadonce:true,
pager: jQuery('#pager'),
height: 'auto',
width: 525,
viewrecords: false,
sortorder: "desc",
gridComplete:function(){
var pIDs = jQuery("#list").jqGrid('getDataIDs');

for(var i=0; i<pIDs.length; i++){
var option='';
var cl = pIDs[i];
fila = jQuery("#list").jqGrid('getRowData', pIDs[i]);
position = fila.posicion;
orden = fila.orden;
btnDelete = "<input style='height:22px;' type='image' src=\"Resources/btn_borrar.png\" onclick=eliminar("+cl+"); float=\"center\"/>";
btnEdit = "<input style='height:22px;' type='image' src=\"Resources/btn_editar.png\" onclick=\"editar("+cl+")\" float=\"center\"/>";
if(position=="Arriba Izquierda" || orden=='1'){
jQuery("#list").jqGrid('setRowData',pIDs[i],{Action:btnEdit});
}
else{
jQuery("#list").jqGrid('setRowData',pIDs[i],{Action:btnEdit});
jQuery("#list").jqGrid('setRowData',pIDs[i],{Action2:btnDelete});
}
}
}
});

$("#list").jqGrid('sortableRows',
{
update : function(e,ui) {

$.getJSON(urlService+"guardarCambios?callback=?",{id:ui.item[0].id,orden:ui.item[0].rowIndex,Programa:programa},
function(data){
jQuery("#list").setGridParam({sortorder: "asc"}).jqGrid("sortGrid", "order_index", true);
jQuery("#list").trigger("reloadGrid");
});

alert("item with id=" + ui.item[0].id + " is droped");
}});
});

i need this Demo

]]> Fri, 30 May 2014 17:13:44 +0300