Office Developer Center: Querying and Updating a Database Using Web Services in InfoPath and ASP.NET

Office Developer Center: Querying and Updating a Database Using Web Services in InfoPath and ASP.NET: "Introduction

This proof-of-concept article demonstrates how some functionality of a Microsoft Office InfoPath solution, based on a Web service, can also be offered as a Microsoft ASP.NET Web application. This is useful when InfoPath is not available on the client computer to fill out a form. Commonly referred to as a 'reach' experience, this kind of browser-based Web application allows a user to edit the same information in the InfoPath form, but without the features of InfoPath, such as rich-text formatting, the ability to check spelling, and the ability to edit the data if a network connection is not available.

The Web service uses the GetCustomers method to return a Microsoft .NET DataSet, which contains records from the Customers table of the Northwind SQL database. The Web service uses the UpdateCustomers method to accept changes to the records. Both methods are used in the InfoPath form template and the ASP.NET Web application, giving each solution the ability to edit the database records.

This article also includes architectural considerations for Web services and information about design limitations of InfoPath. These sections outline problems that can arise when designing and deploying Web services in the enterprise environment, and examine the limitations of InfoPath forms based on Web services."

I was using InfoPath to keep track of many things related to project, and ASP.Net programming is one that intrests me.

The moment I saw this article, I wanted to take a look at this and then as an after thought, blogged it here. To preserve the url for ever