How to show all rows in the jqGrid?

javascript jquery jqgrid rowcount
Jon Erickson picture Jon Erickson · Aug 6, 2009 · Viewed 70.6k times · Source

jqGrid exposes a property rowNum where you can set the number of rows to display for each page. How do you set the grid to just display ALL rows?

Right now I'm just setting the rowNum to something really high like <%= int.MaxValue %> but I'm wondering if there is a better way.

Answer

Justin Ethier picture Justin Ethier · Oct 13, 2009

In the latest version of jqGrid, you can set rowNum to -1 to instruct the grid to always display all rows:

rowNum: -1

See the latest jqGrid documentation here.

Specifically:

Sets how many records we want to view in the grid. This parameter is passed to the url for use by the server routine retrieving the data. Note that if you set this parameter to 10 (i.e. retrieve 10 records) and your server return 15 then only 10 records will be loaded. Set this parameter to -1 (unlimited) to disable this checking.

Related questions

Hidden Columns in jqGrid

Is there any way to hide a column in a jqGrid table, but have it show as read-only when the row is edited in the form editor modal dialog?

Read More
Resize jqGrid when browser is resized?

Is there any way to resize a jqGrid when the browser window is resized? I have tried the method described here but that technique does not work in IE7.

Read More
How to refresh the data in a jqGrid?

I have been trying to get a grid to be updated from the datasource when a button is pushed. So I have in the click event something like this: $('#grid').jqGrid('trigger','reloadGrid'); However this does not work and …

Read More