Connection Object....

[Nelson Smith]

To make my application more efficient whenever I use database connection I
am calling the following statements.

Do I miss some statements or some of them are redundant?

I am using .Net Framework 1.1.



cnnSQL.Close()

cnnSQL.Dispose()

cnnSQL = Nothing



Thanks

Nelson

 

[Steve C. Orr [MVP, MCSD]]

cnnSQL.Close() is all you'll ever need, and you don't even need that in some
cases.
All the rest are redundant.

 

[Kevin Spencer]

cnnSQL.Close() is all you'll ever need, and you don't even need that in
some

cases.

Or cnnSQL.Dispose(). Using either of them will do the trick. Using both, as
Steve says, is redundant. And setting ANY class instance to Nothing does
exactly that: Nothing. Well, it DOES waste a few processing cycles, but
nothing to write home about.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living