Currently I am working on an asp.net mvc 4 web application, and on the index views I have wrote the sorting & paging code manually , which gives me the ability to control how the paging and sorting works. so in my case if I have 10,000 records and the paging size is 50 then only the 50 records will be retrieved from the database, so my current approach can be considered extensible. But currently I am looking to use web grids because it can save me time and efforts. But I need to know if there are any web grids that have the following main features:-
Provide Ajax-base sort, filter and paging
All the sort, filter and paging need to be done on the database level.
The ability for the users to change the number of records displayed, such as show me 100 records, 200 records , etc
The ability to easily change the look and feel of the web grid.
So can anyone advice on available web grids that have the above 4 main features?