Get all rows data of a JQGrid in codebehind?

2019-04-01 13:15发布

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?

2条回答
走好不送
2楼-- · 2019-04-01 14:00

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

查看更多
Rolldiameter
3楼-- · 2019-04-01 14:08

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.

查看更多
登录 后发表回答