DataConnectionCollection class

Each data connection is used to retrieve data (inserted into the main data source or into a secondary data source) or to submit data.

A data connection used to retrieve or submit data for the main data source will correspond to one of the following data connection object types:

• AdoQueryConnection

• AdoSubmitConnection

• WebServiceConnection

A data connection used to retrieve data for a secondary data source will correspond to one of the following data connection object types:

• AdoQueryConnection

• BdcQueryConnection

• FileQueryConnection

• SharePointListRWQueryConnection

  Note
  The SharepointListQueryConnection object used in previous versions of InfoPath has been deprecated.

• WebServiceConnection

A data connection used only for submitting data will correspond to one of the following data connection object types:

• BdcSubmitConnection

• EmailSubmitConnection

• FileSubmitConnection

• SharePointListRWSubmitConnection

• WebServiceConnection

To access a DataConnection object for a particular kind of data connection, use the DataConnectionCollection object associated with the form template. To access the DataConnectionCollection object, use the DataConnections property of the XmlForm class.

To use the properties or methods of the object returned from the DataConnectionCollection, you must cast that object to the type that represents the kind of data connection you are working with before you can access those members. For example, to work with an AdoQueryConnection object (which represents a data connection for retrieving data from an Access or SQL Server database), you must cast the object returned from the DataConnectionCollection as shown in the following examples.

For more information about working with data connections, see How to: Access External Data Sources.

Reference