Open connection

[vuthaianh]

In Web, when i want to do a task associating with database Should i open connection to the database at the beginning of the task and close connection when task is done? OR I open connection when page_load event of the page raises and just close connection when page_unload event of the page raises. Thanks

[Colin Angus Mackay]

I'd write a class (or set of classes) that handles all database interation. Each method open the connection, executes the SQL and then closes the connection.

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious