Using an Include File For Database Connectivity
August 9, 2001
I've found that many ASP developers don't like repetitive tasks, yet many developers do the following: on each page using database connectivity, they write the following code:
Now why write all of this? First off, is a Session variable really needed here? No. Should we have to retype all of this on each page we want to have database connectivity? No. A simpler solution is to use an include file, which contains the above lines (and the connection string hard coded in).
Let's say we do this in a file named
Then, in every page we want to use database connectivity, we just need to add this one line:
Isn't this way much easier? Whenever we need to refer to a database connection
object (such as in the
This tip originally appeared in the Web Technology section of 4GuysFromRolla.com.