jQuery Grid Plugin - jqGrid - Topic: add a row to grid and update table http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table Simple:Press Version 5.7.5.3 iccsi on add a row to grid and update table http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table#p29250 Discussion http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table#p29250 Thanks for the message and help,

I understand, I need use jQuery.ajax to post data to the database and use add row to the grid,

Thanks again for helping,

Regards,

Iccsi,

]]> Thu, 01 Aug 2013 04:22:31 +0300 tony on add a row to grid and update table http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table#p29239 Discussion http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table#p29239 Hello,

jqGrid is client side component ad it does not support any operation to database.

In order to do this you will need first to update the database using ajax and if the update is succesfully you can add the row to the grid.

This can look like:

var datarow = {id:"99″,invdate:"2007-09-01″,name:"test3″,note:"note3″,amount:"400.00″,tax:"30.00″,total:"430.00″};

jQuery.ajax({

url: "url_to_the_server",

data: datarow,

success: function(...){

// here you can add the  row in the grid in order to synchronize:

jQuery("#list5″).jqGrid('addRowData',99,datarow);

}

...

});

Regards

]]> Wed, 31 Jul 2013 13:44:24 +0300 iccsi on add a row to grid and update table http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table#p29238 Discussion http://www.trirand.com/blog/?page_id=393/discussion/add-a-row-to-grid-and-update-table#p29238 jQuery("#a4").click( function(){ var datarow = {id:"99",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}; var su=jQuery("#list5").jqGrid('addRowData',99,datarow); if(su) alert("Succes. Write custom code to add data in server"); else alert("Can not update");

I went to jQuery Grid demo web site and learn to add a record using above method.

It added a row to the grid, but not update database.

Is it possible to add a row to the grid and update table?

Your help and information is great appreciated,

Regards,

Iccsi,

]]> Wed, 31 Jul 2013 02:35:02 +0300