R
Roger Twomey
Hi
I have been disposing of my sql connections for some time (as I should) but
when I see samples I noticed that the samples don't close the connection
first. Here is what I do:
sqlconnection.open
Code
sqlconnection.close
sqlconnection.dispose()
-->>
What I see in samples looks like this:
sqlconnection.open
code
sqlconnection.dispose()
-->>
I noticed that in all the samples (where I noticed at all) that no one was
closing the connection first. Should I bother? Is one method right and the
other wrong? Are there any advantages to closing first or should I NOT close
first?
Does anyone know the answer to this?
Thanks.
I have been disposing of my sql connections for some time (as I should) but
when I see samples I noticed that the samples don't close the connection
first. Here is what I do:
sqlconnection.open
Code
sqlconnection.close
sqlconnection.dispose()
-->>
What I see in samples looks like this:
sqlconnection.open
code
sqlconnection.dispose()
-->>
I noticed that in all the samples (where I noticed at all) that no one was
closing the connection first. Should I bother? Is one method right and the
other wrong? Are there any advantages to closing first or should I NOT close
first?
Does anyone know the answer to this?
Thanks.