adoAdapter Element
Office 2003
Defines an ActiveX Data Objects (ADO) data adapter that retrieves data from an ADO data source for the specified data object.
Type
xsd:complexType
Structure
| Name | Description |
|---|---|
| commandText | (Required attribute) A string property that contains the ADO SQL command text to be used for querying the data from the specified data source. |
| connectionString | (Required attribute) A string property that contains the ADO connection string to be used to connect to the data source. |
| name | (Optional attribute) Contains the name of the adoAdapter element. |
| queryAllowed | (Optional attribute) Specifies whether data can be retrieved from the data source through the Query method of the data adapter object. |
| submitAllowed | (Optional attribute) Specifies whether data can be submitted to the data source through the Submit method of the data adapter object. |
Remarks
The adoAdapter element is an optional element of the query element.
Example
The following is an example of the adoAdapter element:
<xsf:query>
<xsf:adoAdapter
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Password="";User ID=Admin;
Data Source=infnwind.mdb;Mode=Share Deny None;
Extended Properties="";..."
commandText="select [EmployeeID],[LastName],[FirstName]
from [Employees] as [Employees]"
queryAllowed="yes"
submitAllowed="yes">
</xsf:adoAdapter>
</xsf:query>
