What is the most user friendly ASP.NET MVC Grid View Control?

Question

For a new project, we are evaluating the use of ASP.NET MVC and one of the requirements is that we have a very rich UI experience with inline record editing (i.e. the user clicks "edit" and the labels turn into text boxes and drop down lists and can update, delete, or cancel). We need all of the drop down lists to be populated from a database and the selected item should be what was saved...

Along with advanced editing features, we would also like to have filtering, searching, and grouping (grouping is a nice to have).

What options are out there? We've seen jqGrid, but before committing to that wanted to make sure that we were not missing other options.

Clarification
While FREE is great and preferred, if there are third party controls out there available for purchase, we would be willing to consider those options. We also would prefer for editing to occur with inline without redirecting to edit record pages or use modal popups for the edit.

Answer 1

Many people like ExtJs. See here for some examples.

Answer 2

There's a Grid in MVC Contrib

Answer 3

Well, i'm using the MVC contrib grid mixed with a jquery plugin called datatables, i'm very happy with it...coz it provides a rich experience without compromising the data consistency....I've made that decision coz its too much hard to control data consistency and validation in a real time grid. Think about it.

Answer 4

I ended up using the jQGrid for my application. Although the learning curve is not very flat and the grid required quite a bit of programming and configuration through code, it seems to provide outstanding functionality to end users.

From inline editing to paging, sorting, filtering, etc. this grid has it all. Highly recommend it for your future projects...

Answer 5

You can also try Syncfusion MVC grid. It contains all the functionalities like sorting, grouping, filtering, paging and editing (along with custom edit template support) with View Customization support.