how to close the connection used in a strong typed dataset/tableadapter

[adshocker]

hi all,

is there a way to do this?

thanks

 

[Arg81]

As far as I know, the dataAdapter itself still opens and closes the connection, so in a strong typed dataset there is no need to do so.

I think it is only in Untyped datasets you would be required to open and close the connection....

 

[mentalhard]

Absolutelly! The dataadapter object takes care about it automatically. Means, you don't need to do anything additonal to open or close the connection. Just associate the correct connection with the DA and voila you can get relax lol

Otherwise as Arg81 stated already you need to use the Open and Close methods of the connection object.

Connection.Open()
' DO Something
Connection.Close()

HTH

 

[adshocker]

i see... but i need to do a clearpool on my connection. how do i do that with a strong typed datasets? i need to somehow reference the connection so that i can add the code myConn.ClearPool().

 

[JohnH]

YourTypedTableAdapter.Connection

 

[adshocker]

thanks...

although the clear pool did not do what i expected it to do but this is a different topic. if interested please check out http://www.vbdotnetforums.com/showthread.php?t=24039