Mega Code Archive

 

Categories / Visual C++ .NET / ADO Database

 

Close database connection in destructor

#include "stdafx.h" #using "System.dll" #using "System.Data.dll" using namespace System; using namespace System::Data::SqlClient; ref class DataConnection {    SqlConnection^ conn;    public:    DataConnection()    {       conn = gcnew SqlConnection("Server=(local);Uid=sa;Pwd=****;Initial Catalog=master");       conn->Open();    }    ~DataConnection()    {       this->!DataConnection();    }    !DataConnection()    {       try {         Console::WriteLine("Closing connection...");         conn->Close();       }       catch(Exception^ e)       {          Console::WriteLine("Error occurred! " + e->Message);       }    } }; int main() {    DataConnection connection1;    DataConnection^ connection2 = gcnew DataConnection();    GC::Collect(); }