Close database connection in destructor : SqlConnection « Database ADO.net « Visual C++ .NET

Home
Visual C++ .NET
1.2D
2.Class
3.Collections
4.Data Type
5.Database ADO.net
6.Delegate
7.Development
8.File Directory
9.Function
10.Generics
11.GUI Form
12.Language Basics
13.Network
14.Reflection
15.Security
16.Statement
17.Structure
18.Thread
19.XML
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Visual C++ .NET » Database ADO.net » SqlConnection 
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();
}

   
  
Related examples in the same category
1.Make connection to database with SqlConnection
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.