ASP.NET Developer's JumpStart

Creating a Useful Web Service

Although a service that adds two numbers together has its uses (although it might be difficult to determine those uses, except for demonstration purposes), you might be more likely to create a Web Service that interacts with a data source and provides information based on that data. In this section, you'll create a Web Service that retrieves information from the Northwind sample database in SQL Server. You'll provide two methods:

• GetInventory. This method returns the current, available inventory for a specific product.

• GetAllInventory. This method returns a DataSet containing the inventory level for all products.

There really isn't much new in these procedures, because the techniques you've already learned for manipulating ...