I have developed a site in VB.Net and ASP.Net with a database backend that allows a user to enter a centre code and in return it retrieves all records from the datbase where the centre code matches the one provide in the text box.
My list is appearing as required.
I have been given an additional requirement to "enable the user to click on a column and in return it sorts the data in the listbox in ascending or descending order.
For example, a user clicks on the 'Paper Title' column, and then the paper title with the letter earliest in the alphabet appears at the top, and if the user clicks again, the paper with the last letter in the alphabet appears.
Example: user clicks the column header and then 'Art' appears first.
The user clicks on the column again and then 'Science' appears first.
Is there a way to do this at all?
My data is retrieved from the database using a stored procedure.
If there is, can somebody advise??