|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
DataConnection Class (Microsoft.Office.InfoPath)
Assembly: Microsoft.Office.InfoPath (in microsoft.office.infopath.dll)
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:
A data connection used to retrieve data for a secondary data source will correspond to one of the following data connection object types:
A data connection used only for submitting data will correspond to one of the following data connection object types:
To access a DataConnection object for a particular kind of data connection, you 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.
// Get the Employees connection from the // DataConnections collection. AdoQueryConnection myAdoQueryConnection = (AdoQueryConnection)(this.DataConnections["Employees"]);
For more information about working with data connections, see How to: Access External Data Sources.