Hyperlink your data

One of the coolest things you can do with HSP is generate HTML from your relational database data.  HTML Hyperlinks are the ideal way to link relational data, such as Customers, Orders and Products.

Our EzReg program uses HSP and the WOW control to generate and display HTML from relational database data.

All relational data is hyperlinked for easy navigation to related records.  In our EzReg program, we have 3 main entities: Customers, Orders and Products.  In the Orders listing at left, clicking on a Transaction ID displays the Order details ASP page using standard HTML hyperlinking (next screen below).  Clicking on a Customer link in the right column fires an event in the VB code, which informs the application of the action in the webpage, along with information about which item was clicked.

Order Details page with hyperlinks to the Customer and Products in the Order.  Clicking on either of these will fire an event in the application code, which will switch to the appropriate tab and load the page with the item that was clicked.  It does this by calling the Navigate method on the WOW control on the tab, passing the ID of the item as a querystring, something like this:

wowctl.Navigate "x-hsp://" & app.path & "/display_product.asp?id=" & iItem
Customer listing page with hyperlinks.  If the Contact name is hyperlinked, clicking on it opens an email message in your mail program, the same as it would in a normal webbrowser.

All of the pages are dynamically generated using standard ASP with our HSP DLL.
 

Customer details page listing all orders placed by this customer.  The order TransactionID is hyperlinked to allow quick and easy display of order details.

Using HTML for display of data makes it easy to code your UI, besides looking great.
Products listing page, again with hyperlinks to details page.
Product details page.  The button displayed is a HotButton ActiveX control on the webpage.  You can specify a graphic to display and setup the properties of the button to give it any style you want, including XP style.