Create a search box on an mvc 3 list page

Using the MVC 3 framework I wrote a controller which is used to "manage" a series of tables in a database.

This is done in a pretty straightforward manner: the controller supports Index, Create, Edit, Detail and Delete actions. I'm not using any extra controls, just plain old standard aspx functionality. No jquery, ajax, ...

On the index view I show a listing of what's currently in my database table, I would like to add extra functionality:

Add sorting and paging. This isn't necessary for all tables, but some will contain a lot of data.
Add a searchbox on top of the page, which should allow the user to search in the listing he has on his screen.

I've already done some research on the 2nd portion of my question, but can't really find a usable example...

The only one I might be able to use rather quickly, uses jQuery to achieve the 2 goals I mentioned, however, I wonder if there is no other way.

Can some here help me? :-) I've added a sample version of one of the controllers I build and its associated views.

I kept on looking, after trying a couple of variations of my original searchquery on google I ran across the following page:

http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

It contains a small tutorials which shows you how to implement filtering, sorting and paging using standard asp .net component, just as I wanted.

Since I'm using a variation of the repository pattern, I had to rework their code a bit. Nohing big, just where as in their examples all the queries are run from within the Controller, all my database related code can be found in my data layer. Where they directly use the output of their queries, I use DTO classes, classes customized for what they're expected to display/work with, and so on...

You can find a sample of my code in the zip I included.

Incidently, I do have an extra question. Within the application I use a PageList component, this component adds certain functionality to several (pre-existing) classes. What is that called like?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Olivier Muhring14y ago
I kept on looking, after trying a couple of variations of my original searchquery on google I ran across the following page:

http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

It contains a small tutorials which shows you how to implement filtering, sorting and paging using standard asp .net component, just as I wanted.

Since I'm using a variation of the repository pattern, I had to rework their code a bit. Nohing big, just where as in their examples all the queries are run from within the Controller, all my database related code can be found in my data layer. Where they directly use the output of their queries, I use DTO classes, classes customized for what they're expected to display/work with, and so on...

You can find a sample of my code in the zip I included.

Incidently, I do have an extra question. Within the application I use a PageList component, this component adds certain functionality to several (pre-existing) classes. What is that called like?