ConnectionInfo Class
Provides properties for retrieving and setting options for connecting to database servers or ODBC data sources.
Namespace CrystalDecisions.Shared Assembly CrystalDecisions.Shared (CrystalDecisions.Shared.dll)
Syntax
'Declaration
Public Class ConnectionInfo
Implements ICloneable
public class ConnectionInfo : ICloneable
Remarks
When passing an empty string ("") for all parameters except for the password, the program uses the value that's already set in the report. If wanting to override a value that's already set in the report, use a non-empty string.
Example
See Logging onto a Secure SQL Server Database Using SQL Authentication for a tutorial that contains detailed sample code.
This example shows how to set the connection information for a table in the report.
'Declaration
Private Sub SetConnectionInfo(ByVal myTable As String, _
ByVal myServer As String, ByVal myDatabase As String, _
ByVal myUser As String, ByVal myPassword As String)
Dim myLogOnInfo As New TableLogOnInfo()
myLogOnInfo = Report.Database.Tables.Item(myTable).LogOnInfo
Dim myConnectionInfo As New ConnectionInfo()
myConnectionInfo = Report.Database.Tables.Item(myTable).LogOnInfo.ConnectionInfo
myConnectionInfo.DatabaseName = myDatabase
myConnectionInfo.ServerName = myServer
myConnectionInfo.Password = myPassword
myConnectionInfo.UserID = myUser
Report.Database.Tables.Item(myTable).ApplyLogOnInfo(myLogOnInfo)
End Sub
static void SetConnectionInfo (String* table, String* server, String* database, String* user, String* password)
{
TableLogOnInfo* logOnInfo = new TableLogOnInfo();
logOnInfo = Report->Database->Tables->Item [table]->LogOnInfo;
ConnectionInfo* connectionInfo = new ConnectionInfo ();
connectionInfo = logOnInfo->ConnectionInfo;
connectionInfo->DatabaseName = database;
connectionInfo->ServerName = server;
connectionInfo->Password = password;
connectionInfo->UserID = user;
Report->Database->Tables->Item [table]
->ApplyLogOnInfo(logOnInfo);
};
private void SetConnectionInfo (string table, string server, string database, string user, string password)
{
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo = Report.Database.Tables[table].LogOnInfo;
ConnectionInfo connectionInfo = new ConnectionInfo ();
connectionInfo = logOnInfo.ConnectionInfo;
connectionInfo.DatabaseName = database;
connectionInfo.ServerName = server;
connectionInfo.Password = password;
connectionInfo.UserID = user;
Report.Database.Tables [table].ApplyLogOnInfo(logOnInfo);
}
Inheritance Hierarchy
Object
ConnectionInfo
Version Information
Crystal Reports Basic for Visual Studio 2008
Supported since: Crystal Reports for Visual Studio .NET 2002