using {} with SQLConnection

[Ron]

If I wrap a SQLConnection with a using (...){} block will the connection
automatically be closed if an exception occures? Or will I still need a try
block to catch the exception and close the connection?

Thanks,
Ron

[James Swindell]

Using the "using" (i know, i know) will close your database connection.

James

"Ron" <ve*******@nospam.com> wrote in message
news:uh**************@TK2MSFTNGP15.phx.gbl...

If I wrap a SQLConnection with a using (...){} block will the connection
automatically be closed if an exception occures? Or will I still need a
try block to catch the exception and close the connection?

Thanks,
Ron

[Morten Wennevik]

Hi Ron,

using is considered equal to try/finally. The SqlConnection will be disposed even if an exception occurs.
On Thu, 05 May 2005 17:06:33 +0200, Ron <ve*******@nospam.com> wrote:

If I wrap a SQLConnection with a using (...){} block will the connection
automatically be closed if an exception occures? Or will I still need a try
block to catch the exception and close the connection?

Thanks,
Ron

--
Happy coding!
Morten Wennevik [C# MVP]