Datagrid custom sorting and paging using stored procedure

[Mo]

Hi,

I would like to implement a bi-directional (asc / desc) sorting feature on
the columns of my datagrid as well as have custom paging. I have looked at
many code samples out there and they just have basic examples of the
built-in functionality, nothing customized.

I would like to have a custom paging solution which looks like this:

(this Label keeps track of the document numbering)
"Showing 1 - 10 of XXX Documents"
(and these are the navigation links which show page numbers)
<<Prev 1 2 3 4 5 ... Next>>

I would also like to be able to click on any column in the datagrid and sort
it ascending and by clicking it again, sort it descending.

I am using VB.NET with stored procedures to populate the datagrid.

I would greatly appreciate it if anyone can show me how to get this done.

Thanks

 

[FFlannery]

Hey Mo I had to do that... seriously, regarding the sorting, check
out this site: http://aspnet.4guysfromrolla.com/articles/012903-1.aspx

I am in the process of trying to figure out the paging still myself.
So, if either of us find it, post here!!!

Good luck!
Frank