Export (0) Print
Expand All

AdoQueryConnection Class

Represents a connection for retrieving data from a Microsoft Access or Microsoft SQL Server database.

Namespace: Microsoft.Office.InfoPath
Assembly: Microsoft.Office.InfoPath (in microsoft.office.infopath.dll)

The ADOQueryConnection object provides properties that can be used to get and set information about the data connection's connection string, SQL command text, and timeout value. It also provides a method for creating a SQL command text fragment based on a specified XML node's attributes.

When a form designer creates a form template using the New from Data Connection link on the Design a Form task pane, and then selects to create a Database connection, an AdoQueryConnection object for this connection is added to the DataConnectionCollection collection.

If the form designer also enables submitting to this ADO connection, then an AdoSubmitConnection object for this connection is added to the DataConnectionCollection collection.

For both kinds of connection, the name of each connection is specified by the form designer in the Data Connection Wizard user interface. The default names assigned in the wizard for each kind of connection are "Main connection" (AdoQueryConnection) and "Main connection submit" (AdoSubmitConnection).

The AdoQueryConnection class corresponds to the AdoAdapterObject class of the Microsoft Office InfoPath 2003 object model for a connection that is configured to retrieve (query) data from an Access or SQL Server database.

System.Object
   Microsoft.Office.InfoPath.DataConnection
    Microsoft.Office.InfoPath.AdoQueryConnection

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

Show:
© 2014 Microsoft