Closing OleDbConnection?

[chaosmaster]

In order to fully clean up an OleDbConnection, do I explicitly need to close any OleDbDataReaders or can I simply call the .close() method on the connection?

 

Thanks!

[Spiel79]

You might want to dispose of any commands before closing the connection:

Dim MyCommand As New OledbCommand("your command string here")
Dim MyReader As OledbReader(MyCommand, MyConnection)
MyReader.ExecuteReader()
'Continue with the rest of the code...

MyCommand.Dispose()
MyConnection.Close()

Hope that helps

[bungpeng]

What about this? any comments?

 

If Not IsNothing(Con) Then
    If Con.State = ConnectionState.Open Then
         Con.Dispose()
              Con.Close()
         End If
    Con = Nothing
End If