Introducing Microsoft® Office InfoPath™ 2003

Using Web Services as Secondary Data Sources

You can use Web service methods to create a secondary data source that populate drop-down lists. Creating a secondary data source from a Web method with the Data Connection Wizard is similar to the process you used for database tables and queries in the section “Creating Secondary Data Sources for List Boxes,” in Chapter 13.

The NWOrdersWS service has five Web methods designed for secondary data source use: GetCustomers, GetProducts, GetProductsDetailed, GetShippers, GetEmployees, and GetLast10Orders. All but the GetLast10Orders method return a serialized object; GetLast10Orders returns an array of integers. A drop-down list of the last 10 orders added to the database is useful to populate a list ...