ASP dynamic header sorting

[suprapen]

I am new to ASP, was trying to convert the following sorting scripts from:

http://www.asp101.com/samples/db_sort_arrows.asp

I got everything to work except for the header names, how can I not use the database field names for the header names? My database field names are tough for everyday users to comprehend what that column actually is for.

for example, lst_name, frst_name is my field names, I want the header names to be Last Name and First Name.

Any help would be greatly appreciated. Hope some experts here can help. Thank you!

 

[TheCandyman]

I would point you here is you really want a simple sort for the users:

http://www.kryogenix.org/code/browser/sorttable/

It uses javascript to sort and it doesn't make you reload the page(which is nice).

As far as your naming for your columns, you can name them whatever you want. If you show some code we can actually help you (which is why no one has helped yet)