Sorting & custom paging in datagrid using stored procedure 2

[xtremeLogic]

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

 

[crazyboybert]

Hi xtreme

This is a big subject and there is a lot of code and decisions to be made behind what you are asking for. Somebody may have time to create and post an example for you to use here but there are masses out there.

This is something I have had to tackle a number of times at work in varying incarnations and it's not been too tricky.

MSDN and 4guys between them have some pretty handy articles on this subject which should get you underway...

http://msdn.microsoft.com/library/d...en-us/dnaspp/html/aspnet-pageablesortable.asp

http://dn.yyyz.net/DnYzArticleShow.aspx?WA=13

(probably same M$oft code as above)

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

(start of the 4guysfromrolla series on datagrids covers both paging and sorting)

http://www.4guysfromrolla.com/webtech/010704-1.shtml

(a very recent article on dynamic order bys in stored procedures - very useful for sorting datagrids)

Hopefully that should get you started and cover most of the issues you come across.

Good luck and enjoy

Rob

Go placidly amidst the noise and haste, and remember what peace there may be in silence - Erhmann 1927