ASP.NET MVC 3 WebGrid paging issue

c# asp.net-mvc asp.net-mvc-3 webgrid
Daniil Harik picture Daniil Harik · Nov 15, 2010 · Viewed 15.8k times · Source

My data access layer returns collection with rows for single page and total number of rows.

Unfortunately WebGrid component does not allow to specify total number of rows or total number of pages (these properties are read-only).

Has anyone had to deal with this issue before?

Answer

Einar Arne picture Einar Arne · Dec 30, 2010

You can use the Bind method on the WebGrid to tell the grid to use server side paging.

grdv.Bind(myData, rowCount=10000, autoSortAndPage=False)

Setting autoSortAndPage to false tells the grid that myData is just a segment of the data. It will show all rows of this data regardless of your page size setting. Pager will be built using the rowCount you pass in and not the number of records in myData.

Related questions

Filter is getting lost in WebGrid + Paging + Sorting + Filtering in .NET 4.0

I've implemented a WebGrid. Sorting, paging and filtering do not work together. They work when you use them alone. When you combine the three, at the same time, filtering doesn't work. The symptom: Filter the resultset, then sort. or Filter …

Read More
WebGrid Column Format Issue in MVC3

I've been trying to change the format of a single column in a WebGrid without much success. Said column is this: grid.Column( columnName: "EmailAddress", header: "Email Address", format:(item) => Html.EmailLink(item.EmailAddress, item.EmailAddress, ""), canSort: false ), The …

Read More
Returning a file to View/Download in ASP.NET MVC

I'm encountering a problem sending files stored in a database back to the user in ASP.NET MVC. What I want is a view listing two links, one to view the file and let the mimetype sent to the browser …

Read More