ConnectionInfo 類別
提供連接到資料庫伺服器或 ODBC 資料來源的擷取和設定選項屬性。
如需這個類型所有成員的清單,請參閱 ConnectionInfo 成員。
ConnectionInfo
[Visual Basic]
Public Class ConnectionInfo
[C#]
public class ConnectionInfo
[C++]
__gc public class ConnectionInfo
[VJ#]
public class ConnectionInfo
註解
在傳遞除了密碼之外所有參數的空字串 ("") 時,程式會使用報表中已經設定的值。如果要覆寫報表中已設定的值,請使用非空的字串。
範例
這個範例說明如何在報表中設定資料表的連接資訊。
[Visual Basic]
Private Sub SetConnectionInfo(ByVal table As String, _
ByVal server As String, ByVal database As String, _
ByVal user As String, ByVal password As String)
' 取得 ConnectionInfo 物件。
Dim logOnInfo As New TableLogOnInfo()
logOnInfo = Report.Database.Tables.Item(table).LogOnInfo
Dim connectionInfo As New ConnectionInfo()
connectionInfo = Report.Database.Tables.Item(table).LogOnInfo.ConnectionInfo
' 設定連接參數。
connectionInfo.DatabaseName = database
connectionInfo.ServerName = server
connectionInfo.Password = password
connectionInfo.UserID = user
Report.Database.Tables.Item(table).ApplyLogOnInfo(logOnInfo)
End Sub
[C#]
private void SetConnectionInfo (string table, string server, string database, string user, string password)
{
// 取得 ConnectionInfo 物件。
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);
}
[C++]
static void SetConnectionInfo (String* table, String* server, String* database, String* user, String* password)
{
// 取得 ConnectionInfo 物件。
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);
};
[VJ#]
private void SetConnectionInfo (String table, String server, String database, String user, String password)
{
// 取得 ConnectionInfo 物件。
TableLogOnInfo logOnInfo = new TableLogOnInfo();
LogOnInfo = Report.get_Database().get_Tables().get_Item(table).get_LogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo ();
connectionInfo = logOnInfo.get_ConnectionInfo();
// 設定連接參數。
connectionInfo.set_DatabaseName(database);
connectionInfo.set_ServerName(server);
connectionInfo.set_Password(password);
connectionInfo.set_UserID(user);
Report.get_Database().get_Tables().get_Item (table).ApplyLogOnInfo(logOnInfo);
}
需求
**平台:**Windows 98、Windows NT 4.0、Windows Millennium Edition、Windows 2000
**組件:**CrystalDecisions.Shared (CrystalDecisions.Shared.dll)