List of Listings

Chapter 1: Anatomy of the Microsoft Office System 2003

Listing 1.1: Creating a Web Service-based dataset that returns SQL Server data.

Listing 1.2: Generating the Pivot Table from the dataset returned by a Web Service.

Chapter 2: Understanding the InfoPath IDE

Listing 2.1: Employee Contact form.

Listing 2.2

Listing 2.3: The structured XML format of the template definition file.

Chapter 3: Generating XML Forms

Listing 3.1: An XML file that describes an employee.

Listing 3.2: The schema.xsd file defined within the InfoPath solution.

Listing 3.3: XSD representing an employee.

Listing 3.4: A sample XML schema that appears as extensible within InfoPath.

Listing 3.5: An extensible schema that allows you to add non-schema namespaces.

Listing 3.6:

Listing 3.7: The OnAfterChange event that calls the time calculation function.

Listing 3.8: Calculating the time worked by the employee.

Listing 3.9: Calculating the time worked and updating the node fields.

Chapter 4: Generating Web Service Forms

Listing 4.1

Listing 4.2: Performing an insert into an SQL Server database using ADO.NET.

Listing 4.3

Listing 4.4: A document/literal SOAP message.

Listing 4.5: An RPC SOAP message.

Listing 4.6: The network trace generated by an InfoPath solution communicating with the Web Service.

Listing 4.7: Example of converting a dataset to a format that InfoPath can understand.

Listing 4.8: Events fired when Web Service data is returned.

Listing 4.9: Submitting the entire InfoPath DOM to a Web Service.

Listing 4.10: Defining a custom SOAP submission.

Chapter 5: Generating Database Forms

Listing 5.1

Listing 5.2: An Office Database Connection file for the MyCompany database.

Listing 5.3: An example of a persisted database connection.

Listing 5.4

Listing 5.5: An example of a persisted secondary data source.

Listing 5.6: The OnClick event for the Invoice Lookup application.

Listing 5.7: The shape provider statement created by the data source adapter.

Listing 5.8: SQL query persisted by the InfoPath solution.

Chapter 6: Building Workflow-Enabled Applications

Listing 6.1

Listing 6.2

Listing 6.3: Creating a custom email message using the MailEnvelope property.

Listing 6.4: Attaching an InfoPath form to an e-mail using the ShowMailItem method.

Listing 6.5: Web Service for submitting Help Desk requests .

Listing 6.6: Web Service for connecting a secondary datasource.

Listing 6.7: Retrieving data for the Help Desk scorecard.

Chapter 8: Building Smart Client Applications

Listing 8.1: Web Service that returns a catalog dataset to the client.

Listing 8.2

Listing 8.3: XML file showing customer contact information.

Listing 8.4: XSLT applied to the customer data that generates an HTML page.

Listing 8.5

Listing 8.6: XSLT style sheet used to format the InfoPath saved XML.

Listing 8.7

Listing 8.8

Chapter 9: Securing Solutions

Listing 9.1:

Listing 9.2: Modified manifest.xsd for a fully trusted form.

Listing 9.3: Web Service with restricted permissions.

Listing 9.4: Web Service restricted only to the BUILTIN\Sales group .

Chapter 10: Deployment Strategies

Listing 10.1: Default machine configuration file.

Listing 10.2: XSD for the New Candidate Questionnaire.

Appendix A: InfoPath Object Model Reference

Listing A.1: Looping Through The Windows Collection.

Listing A.2:

Listing A.3:

Listing A.4: