MVC3 razor Webgrid paging and sorting with over 2000 entries

I am using a webgrid similar to that described here

@{
    var grid = new WebGrid(canPage: true, rowsPerPage: ThisController.PageSize, canSort: true, ajaxUpdateContainerId: "grid");
    grid.Bind(Model.Employees, rowCount: Model.TotalRecords, autoSortAndPage: false);
    grid.Pager(WebGridPagerModes.All);
    @grid.GetHtml(htmlAttributes: new { id="grid" },
        columns: grid.Columns(
            grid.Column(format: (item) => Html.ActionLink("Edit", "Edit", new { EmployeeID = item.EmployeeID })),
            grid.Column("FullName"),
            grid.Column("Title")
        ));
}

But in my case, I expect more than 2000 entries, I want to load only 50 entries on each page so that the page loads faster. How can I guarantee that only the first 50 entries are loaded when the page loads. When my user clicks on page2, I want to load the next 50 recordsets and so on. Have any of you come across something similar, please offer me a sample code

+5
source share
4 answers

This MSDN journal article shows what you want:

Get the most out of WebGrid in ASP.NET MVC

:

, , (295 , ). , , . theres : . , (, ).

+4

. , webgrid .

- WebGrid

, !

0

@{   var grid = new WebGrid (canPage: true, rowsPerPage: 50, canSort: true, ajaxUpdateContainerId: "grid" );

- ,

}

rowsperpage: ,

-1
List<WebGridColumn> webGridColumn=new List<WebGridColumn>();
var grid=new WebGrid(source:model,
defaultSort:"stk_code",
rowsPerPage:Model.Count(),
canPage:true,
canSort:true);
webGridColumn.Add(grid.Column("stcode",header:"Stock Code",canSort:false));
-2
source

All Articles