|
|
|
A CtreeSqlConnection object represents a unique session to a FairCom DB SQL database. When you create an instance of CtreeSqlConnection, all properties are set to their initial values: the database name is set to “c-treeSQL”, the username and password are set to empty strings, the database server address is set to “localhost” and the service is set to “6597”. If the CtreeSqlConnection goes out of scope, it is not closed. Therefore, you must explicitly close the connection by calling the methods Close() or Dispose().
The following examples shows how to connect to a FairCom DB SQL database using the FairCom DB Data Provider and when the connection is no longer needed, close the connection.
.NET VB Example
Sub Connect()
Dim conString As String = “User=ADMIN;Password=ADMIN;Database=ctreeSQL”
Dim hConnection As New CtreeSqlConnection(conString)
hConnection.Open()
... perform some operations ...
hConnection.Close()
End Sub
.NET C# Example
void Connect()
{
String conString = “User=ADMIN;Password=ADMIN;Database=ctreeSQL”;
CtreeSqlConnection hConnection = new CtreeSqlConnection(conString);
hConnection.Open();
... perform some operations ...
hConnection.Close();
}
.NET C++ Example
void Connect()
{
String* conString = S“User=ADMIN;Password=ADMIN;Database=ctreeSQL”;
CtreeSqlConnection* hConnection = new CtreeSqlConnection(conString);
hConnection->Open();
... perform some operations ...
hConnection->Close();
}
.NET Delphi Example
procedure Connect()
var
conString : String;
hConnection : CtreeSqlConnection;
begin
conString := 'User=ADMIN;Password=ADMIN;Database=ctreeSQL';
hConnection := CtreeSqlConnection.Create(conString);
hConnection.Open();
... perform some operations ...
hConnection.Close();
end;
