I have a page that lists people and I want to allow the user to resort on name / city / title / etc. (This is classic ASP). I have now stored all my data in a recordset, so that I can sort it properly the first time through.
That works.
Now I want to allow them to click on a column heading to resort. I can determine which column they clicked on, but how do I get the data back. I really don't want to re-query the DB, the retrieval logic isn't trivial. If I store the data in a Session (which I understand is discouraged), how do I get it back into the recordset? Is there a better way.
I can't find any articles about this on the Web, keep wading through all the .NET solutions.
THKS.
That works.
Now I want to allow them to click on a column heading to resort. I can determine which column they clicked on, but how do I get the data back. I really don't want to re-query the DB, the retrieval logic isn't trivial. If I store the data in a Session (which I understand is discouraged), how do I get it back into the recordset? Is there a better way.
I can't find any articles about this on the Web, keep wading through all the .NET solutions.
THKS.