About the Data Interop Developer Sample Form [InfoPath 2003 SDK Documentation]

  • Article

Applies to:

Microsoft Office InfoPath 2003

For information on working with master/detail controls, see "About master/detail controls" in the InfoPath 2003 Help.

The Data Interop developer sample form uses Microsoft ActiveX Data Objects (ADO) to demonstrate how a Microsoft Office InfoPath 2003 form can be used to connect to a Microsoft SQL Server database and retrieve and modify data in the database. The Data Interop developer sample form demonstrates how to handle offline data submission. The Data Interop developer sample form also shows how you can use multiple views with queries to create reports.

The Data Interop developer sample form is based on an order-tracking scenario, and it uses the SQL Server Northwind sample database.

Important  In order to use the Data Interop developer sample form, you must use the InfoPath SDK Configuration utility to configure the form. For more information about using the InfoPath SDK Configuration utility, see Configuring the Developer Sample Forms.

To test the features of the sample form, select an employee from the Employee drop-down list box and then click Query. The form switches to Orders view, which lists the orders for the specified employee. You can use the custom toolbar or the task pane to create a new order, search existing orders, or summarize existing orders. You can also switch between online and offline mode by clicking Online/Offline on the custom toolbar in the form. Data submitted while the user is offline is cached on the client computer, and is submitted to the data source when the the user switches to online mode.

Note  To see all of the files that make up the Data Interop developer sample form, open the form and click Extract Form Files on the File menu while in design mode. This extracts all of the form files from the form template file and saves them to a specified folder on your hard disk.

To learn how the to use the features that are implemented in the Data Interop developer sample form, see the following topics:

Connecting to Databases in the Data Interop Developer Sample Form

Retrieving Data and Creating Records in the Data Interop Developer Sample Form

Filtering, Viewing, and Adding Data in the Data Interop Developer Sample Form

See Also | About the SDK Developer Sample Forms