DataAdapter.Dispose

[Simon Harris]

Hi All,

You may have seen my post earlier in the week about using conn.close and
conn.dispose (Thanks Karl for your answers!)

I've read in my MS study guide that DataAdapters open and close database
connections automatically.

So, can I just call DataAdapterInstance.Dispose ?

Previously I have called conn.close (conn.dispose from now on!) but is
there
any need for me to explicily close the connection?

Maybe I'm splitting hairs here...70-305 exam this afternoon! would be good
to know.

Cheers!
Simon.
--
I am using the free version of SPAMfighter for private users.
It has removed 2440 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!

[Scott Allen]

Dispose is freeing the connection, there is no need to call both
Dispose and Close. If are are using the Fill method on the data
adapter, then the adapter will open the connection if it isn't open,
and if the adapter opens the connection it will also properly clean it
up before the Fill method returns.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 2 Jun 2005 11:17:27 +0100, "Simon Harris"
<to***********@makes-you-fat.com> wrote:

Hi All,

You may have seen my post earlier in the week about using conn.close and
conn.dispose (Thanks Karl for your answers!)

I've read in my MS study guide that DataAdapters open and close database
connections automatically.

So, can I just call DataAdapterInstance.Dispose ?

Previously I have called conn.close (conn.dispose from now on!) but is
there
any need for me to explicily close the connection?

Maybe I'm splitting hairs here...70-305 exam this afternoon! would be good
to know.

Cheers!
Simon.