Reuse the same oledb.connection object for each aspx form (global.asax?)
Posted on 2004-08-23
I've been looking for this forever.
It just doesn't feel right to recreate a connection object with the same properties (e.g. connectionstring) for each aspx form...
Is there a way to make one connection object (preferably in designtime) and reuse that instance without needing to create one for every form?
It would be nice if I could stil use this same connection when I need to enter it as a property in the .NET enviroment (for example, you need to associate a connection object with a oledb command etc...)
Any help is appreciated!