I'm adding some rows data to my JQGrid on client side with javascript :
var grid = jQuery("#<%= JQGridMembers.ClientID %>");
var rowKey = grid.getGridParam("selrow");
var newRow = [{ ID: memberId, FullName: memberFullName, Percent: parseInt(percent)}];
grid.addRowData(memberId, newRow);
above code works well , but How can I get all inserted rows data (in JQGrid) in code-behind?
You can get all rows from the grid by
var myData = grid.jqGrid('getRowData');
or with respect of
var myData = grid.jqGrid('getGridParam', 'data');
The last way can be used only with local datatype
or in case of loadonce: true
. It returns data not only from the current page, but all data from all pages.
The getRowData
method use unformatter to read the data from all cells of the grid.
Had encountered a similar problem, below is what I ended up using
var data = $("#table-id").jqGrid('getGridParam', 'data');
for (var i = 0; i < data.length; i++) {
var f_name = data[i].FirstName;
var l_name = data[i].LastName;
// blah... blah..
}
Reference