Export (0) Print
Expand All
Expand Minimize

adoAdapter Element

Office 2007

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

NameDescription
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=&quot;&quot;;User ID=Admin;
         Data Source=infnwind.mdb;Mode=Share Deny None;
         Extended Properties=&quot;&quot;;..."
      commandText="select [EmployeeID],[LastName],[FirstName] 
         from [Employees] as [Employees]" 
      queryAllowed="yes"
      submitAllowed="yes">
   </xsf:adoAdapter>
</xsf:query>


Community Additions

ADD
Show:
© 2014 Microsoft