I would like advice on the pros and cons of declaring a database connection in the various scopes available to us.
What are the pro's / con's of declaring your database connection as:
Global ( open when mdi load, close when it closes )
Form wide ( connect in _load, close in _formclose )
Procedure Level ( connect only when accessing data and immediately close )
I thank you for your replies
Vb.net and sql or ole dbs
Edited by RHankinsJr, 05 November 2011 - 02:20 PM.