adoAdapter Element

Microsoft Office InfoPath

previous page next page

Show All Show All

adoAdapter Element

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=&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>
previous page start next page