Using this tip, you can create a drop-down list, which is populated from a database, and include it in a Web (ASP) page. This will basically increase the performance via the conventional method.
First, you will use a trigger to write to a file whenever the database table is updated. The text in this file will be of type:
Name this file ‘select.inc’.
Then, you will include this file wherever you want a select control to be shown in an ASP page.
<% %>
This will be converted to the following HTML at run-time:
