Query Result Paging with different Ordering

[J Rieggle]

Hi,

I have posted to multiple groups - I hope this is ok.

For the past week or so I have been trying to find out how to perform a
search against SQL Server, and have the results sorted on a choice made by
the UI (ASP.NET), and supports paging. I have trawled the net a number of
times, and have spent hours looking through peoples examples which just dont
seem to cut it, due to all their caveats. Can someone offer good, useful
links on how I can do this type of functionality?

Vry much appreciated, after so much reading and playing I am still little
further forward. I am not a DB person, which is causing part of the
problem.

Thanks

j.r

 

[Roji. P. Thomas]

These might help

http://www.aspfaq.com/show.asp?id=2120
http://www.sommarskog.se/dyn-search.html