Alright just to get this clear in my head. Which construct is better?


Function getData1()

'Open New Connection object

......


'Close New Connection object

End function


Or


Function getData2()

'Get Shared Connection object


If cn.State = "Open" then


'Use Connection

'Close shared connection

end function

I think you understand where I'm getting at. Thanks

<klj_m***@hotmail.com> wrote in message
Since connection objects are pooled, I'd say split the logic up into tiers..
Anywho, create a new connection and open it everytime you need access to a
database record.  Unless you are doing mass updates at once, this is the
recommended way of doing it ;)

Mythran

Thanks! That is what I thought but I read somewhere that you should be
using a shared connection object throughtout your application.

Passing 2 paramter to store procedure ???
Problem Deploying App That Uses ADOX
the_difference_between_SqlConnection.IDisposable.Disp=ADose()_and_SqlConnection.Dispose()
ODBC connection works, but connection string doesn't
How to add new row to typed dataset