ADOAdapter2.Connection property
Gets or sets the connection string used for an ADOAdapterObject object.
Namespace: Microsoft.Office.Interop.InfoPath.SemiTrust
Assembly: Microsoft.Office.Interop.InfoPath.SemiTrust (in Microsoft.Office.Interop.InfoPath.SemiTrust.dll)
Syntax
'Declaration
Property Connection As String
Get
Set
'Usage
Dim instance As ADOAdapter2
Dim value As String
value = instance.Connection
instance.Connection = value
string Connection { get; set; }
Property value
Type: System.String
Implements
Remarks
The Connection property of the ADOAdapter object contains the connection string that is used by the ADO data adapter to connect to an ActiveX Data Objects/OLEDB external data source.
Note
The ADOAdapter object is limited to work only with Microsoft SQL Server and Microsoft Access databases.
Important
This member can be accessed only by forms running in the same domain as the currently open form, or by forms that have been granted cross-domain permissions.
Examples
// retrieve the Employees Adapter from the DataAdapters collection
ADOAdapter employeesDA = (ADOAdapter)thisXDocument.DataAdapters["Employees"];
// Get new server name from the main DOM
string newServer = thisXDocument.DOM.selectSingleNode("//my:serverName").text;
// build new connection string
string connectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;";
connectionString += "Initial Catalog=SalesDB;Data Source=" + newServer;
// set new connection string
employeesDA.Connection = connectionString;
// query the data source again
DataObject employeesDO = thisXDocument.DataObjects["Employees"];
employeesDO.Query();