DataSource.QueryConnection Property

  • Article

Gets a reference to the DataConnection object associated with the data source.

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

Syntax

'Declaration
'Usage

Property Value

A DataConnection associated with the data source.

Remarks

After you have set a reference to the DataConnection object that the QueryConnection property returns, you can use the properties and methods that the particular DataConnection object provides.

This member can be accessed only by forms running in the same domain as the currently open form, or by forms that have been granted cross-domain permissions.

This type or member can be accessed from code running in forms opened in Microsoft Office InfoPath 2007 or in a Web browser.

Example

In the following example, the QueryConnection property of the DataSource object is used to return a reference to the data connection that is associated with the DataSource object, which in this example is an ADOQueryConnection object. The code then uses the Command property of the ADOQueryConnection class to display the SQL command text in a message box.

AdoQueryConnection myConnection = 
   (AdoQueryConnection)(this.DataSources["CityList"].QueryConnection);
MessageBox.Show("SQL command text: " + myConnection.Command);

Dim myConnection As AdoQueryConnection  = _
   DirectCast(Me.DataSources("CityList").QueryConnection, _
   AdoQueryConnection) ;
MessageBox.Show("SQL command text: " & myConnection.Command)

See Also

Reference

DataSource Class
DataSource Members
Microsoft.Office.InfoPath Namespace