ASP.NET MVC. Clean way to implement persistant sorting?

Question

I still haven`t found any example of sorting implementation through paging in ASP.NET MVC
(sort by name->press page 2->page 2 is still sorted by name).

I could "hack" it, make it dirty, but i`m sure there have to be good "how-to" guides for this.

What about sorting by two columns?

Aleris · Accepted Answer · 2009-04-01 08:05:03Z

4

Just keep the sort expression in your model view and write it to the pagination route links.
For example like:

/MyEntity/Page/2?sort=Name

Or with custom routing like:

/MyEntity/Page/2/Name

For the latter the route mapping would look like:

{controller}/Page/{pageIndex}/{sortExpression}

answered Apr 1, 2009 at 8:05

Aleris

8,0694 gold badges39 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Arnis Lapsa Over a year ago

If i remember correct - thing that confused me was that my views "had to know about", as i thought - database structure. You know - sort expressions kind a maps with column names. Funny. It's always nice to find out how dumb i was.

Mike Geise · Accepted Answer · 2009-04-01 11:05:33Z

2

I do it exactly the way aleris does except I use a enum field on my model for the sort values, this way it will fall back on the default if they enter a sort paremeter that doesn't exist.

public enum SortArticle
{
   Title,
   Published
}

public enum SortOrder
{
   Asc,
   Desc
}

articles/{sort}/{order}/{page}
articles/published/desc/1

answered Apr 1, 2009 at 11:05

Mike Geise

8258 silver badges15 bronze badges

1 Comment

Arnis Lapsa Over a year ago

These answers made me just a little bit less confused. Still cant visualize this A-Z. Ill try to create a small example project for myself. If that will be success, Aleris will get my "accepted answer". :)

Collectives™ on Stack Overflow

ASP.NET MVC. Clean way to implement persistant sorting?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related