ADOAdapter2.Connection Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets the connection string used for an ADOAdapterObject object.
public:
property System::String ^ Connection { System::String ^ get(); void set(System::String ^ value); };
public string Connection { get; set; }
member this.Connection : string with get, set
Public Property Connection As String
Property Value
Implements
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.<span class="label">Connection </span>= connectionString;
// query the data source again
DataObject employeesDO = thisXDocument.DataObjects["Employees"];
employeesDO.Query();
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.
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기