edit multiple cells of column at a time in jqxgrid

[ravishankar.knlnParticipant]

Hi Team,

i have a jqxgrid populated with json data coming from database, which is fine till now.
also have another excel with me with modified data other than the one got from db to grid.
ie, i have sno, name, marks fields in jqx grid populated from db, in excel i have new set of marks for the same sno, name.
here i need to select only the marks columns values of 4 or 5 cell values from excel and able to paste in the column cells of marks in jqxgrid.
How to achieve it.

In short i need to drag/select multiple cells of single column and able to paste the values into those selected cells and update back to database.

[Peter StoevKeymaster]

Hi ravishankar,

multiplecellsadvanced selection mode allows you to select multiple cells. Cut, Copy and Paste clipboard operations are supported by default.

Example: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/defaultfunctionality.htm?arctic

To update your DB, you will have to make AJAX call with updated values. When a cell or row is updated, the dataadapter’s source object “updaterow” callback function is called. There you can make the AJAX call to your DB with updated data.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[ravishankar.knlnParticipant]

yes, this works with keypad keys ctrl+C, ctrl+v. just trying to see on mouse events. but anyway for present situation i can manage with keyboard keys.

[Author]

Posts