Introducing Microsoft® Office InfoPath™ 2003

Creating a Form That Receives and Submits Data

Creating a Web service–based InfoPath form that receives and submits persistent data usually requires access to a database service that enables updates. InfoPath data documents generated from Web service–enabled databases have a more conventional structure than those created by the direct database connections that use InfoPath’s ADOAdapter. The OakLeaf XML Web services demonstration site provides a NWOrdersWS Web service that permits editing and updating a very large version of the NorthwindCS sample database. The database contains about 200,000 Orders records and 500,000 Order Details records. The Web service uses SQL Server stored procedures to retrieve, update, and create new Orders and Order ...