ASP.NET

ASP.NET RSS

When to close a db connection?

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2008

Posts: 19

Reputation: mcgarry101 is an unknown quantity at this point

Solved Threads: 0

mcgarry101 mcgarry101 is offline

Offline

Newbie Poster

When to close a db connection?

Dec 3rd, 2008

Hi,

just a quick question from a newbie! I have recently inherited an asp.net website from an ex-colleague and I have a question regarding db connections. I am using vb.net for code behind with an oracle 9 database. The site at the moment, sets up a database connection GDBConn in the session_start sub found in global.asax.vb. This is then used throughout the site. It then doesnt close it until the session_end. However, I was wondering if anyone could tell me if it would be better to be closing these connections immediately after using them. For example, I have a fillGridView function I use to fill my gridviews. In the finally section of this should I be closing my db connection? I am already calling

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
DbComm.Parameters.Clear()
DbComm.Dispose()
DbRead.Close()
DbComm.Parameters.Clear()
DbComm.Dispose()
DbRead.Close()

but should I be closing the connection too?
Any help would be really appreciated.

Thanks,

David.

•

Join Date: Mar 2008

Posts: 268

Reputation: Traicey is an unknown quantity at this point

Solved Threads: 19

Traicey

Offline

Posting Whiz in Training

Re: When to close a db connection?

Dec 4th, 2008

Yah sure if u open the connection u surely need to close it and the best way to close connection is to close it in a finally statement if u have try/catch statement or just after using it, it is not a good practise to leave the connection open and it also bogs down the DB Server, so close it whenever u opened it

Some people get so rich they lose all respect for humanity. That's how rich I want to be.

•

Join Date: Jan 2007

Posts: 101

Reputation: PirateTUX is an unknown quantity at this point

Solved Threads: 3

PirateTUX

Online

Junior Poster

Re: When to close a db connection?

Dec 4th, 2008

I concur... I always close my DB connections right after I'm done with whatever group of transactions I needed the connection for. It makes it easier for me to remember when things are cleaned up, and doesn't leave any connections dangling opened.

WolfWorkz Studios - Server Development
WolfWorkz.com
Pirates Registration
My Personal Blog
SideBySideGeek.com - My Newest Project