New Posts New Posts RSS Feed: Multi-Column Sorting
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Multi-Column Sorting
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
Linguinut View Drop Down
Senior Member
Senior Member
Avatar

Joined: 14-Jun-2007
Location: United States
Posts: 394 		Post Options Post Options   Quote Linguinut Quote  Post ReplyReply Direct Link To This Post Topic: Multi-Column Sorting
    Posted: 11-Jul-2007 at 5:08pm

Does anyone have a clear code example of sorting an entity list by two columns?  For instance, an employee list sorted by last name, then by first name.  I have read the BindableList(of T) doc, but am more confused on the issue than ever.

Thanks,
Bill
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Posted: 12-Jul-2007 at 8:18am
Bill,
 
Here is a simple example that sorts Employee by first and last name.
 
David
 
Back to Top
Linguinut View Drop Down
Senior Member
Senior Member
Avatar

Joined: 14-Jun-2007
Location: United States
Posts: 394 		Post Options Post Options   Quote Linguinut Quote  Post ReplyReply Direct Link To This Post Posted: 12-Jul-2007 at 9:49am
"Simple" is obviously a relative term.  Thanks a ton for the code example!  I am afraid that it does not pose itself as simple, though.  Simple is the SQL syntax of:
 
ORDER BY FirstName, LastName
 
I suppose a passthrough query would be an option rather than this IComparer shenanigans.  I'll give that a try, instead.
 
Thanks,
Bill
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down