Hello,
I believe what you have found on the hqhair site is something commonly referred to as a "landing page" for search engines. It is not dependent on ASP to work. The site owner has identified these common terms used in their industry and has created a page to try and attract the search engines. It could have been done in plain HTML if they desired.
A good free resource for determining popular search terms can be found at Overture.com (click "Visit the resource center", then "Keyword selector tool").
In ASP, if you wanted, you could also track and build a database of terms sent to you by search engines by parsing the Refering URL each time someone is referred into your site. You would need to add this code to each of your site's web pages because you never know where someone is going to land in your site. This same information is commonly available in your web hosts statistics package.