When to open/close the MySQLConnector

[Stuart McCullough]

Hi All,

I'm in the throw of my first web construction and have been thrown in at the deep end with my only tech support being the web.

Anyway - i have a asp.net web site comprising of a master page and two content pages, which is populated from a mySql database. At the moment I am opening and closing the database connection each time i want to call a stored procedure (in response to a button press for example).

I have doubts this is the most efficient way to do things so my question is this - when/where should I handle the opening and closing of the connection? for example - can it be held in a session variable or a global?

I'm sure someone will have a nice link to a "website architecture for dummies" tutorial somewhere :-)

Cheers
/stuart