You will create the Inventory Web service that allows online access to up-to-date inventory information of the stock at the headquarters of JB Book Sellers. This Web service simply needs to retrieve some data from an SQL Server 2000 database and make it accessible online. You will construct the Web service by using the tools available with the SQL XML 3.0 pack.
Creating the Database
The database at the head office of JB Book Sellers contains the InventoryData table, as shown in Figure.
The InventoryData Table.
The InventoryData table maintains an inventory of the available stock. After creating the database, the next step is to create a stored procedure, GetInventory, which retrieves the inventory information from the table.
You use the SQL Server 2000 Enterprise Manager to create the following stored procedure: CREATE PROCEDURE DBO.GetInventory ASSelect Title,Category,Author,Price,Stock from InventoryDataGO
Creating the Web Service for JB Book Sellers
After you create the database and the stored procedure, create a Web service to expose the stored procedure. You learned the steps to create Web service in the earlier section "Creating a Web Service."
After you have finished the steps, you will find that the following files have been created:
The WSDL file contains the description of the Web service required by client applications and maps the methods exposed by the Web service to the corresponding stored procedures. To do this, an .ssc file is generated. The following code is a sample .ssc file that connects the Web service to the stored procedure:
This creates the Web service. You can test it by creating a client application in Visual Basic 6.0, as discussed in the section, "Testing the Web Service."
XML Related Interview Questions
|Soap Tool Interview Questions||HTML Interview Questions|
|PHP Interview Questions||ASP.NET Interview Questions|
|PHP5 Interview Questions||Java Interview Questions|
|CSS Interview Questions||XSLT Interview Questions|
|Java XML Interview Questions||XMLHttpRequest (XHR) Interview Questions|
|ebXML Interview Questions||XML DOM Interview Questions|
|XML-RPC Interview Questions||XSD Interview Questions|
|Soap Web Services Interview Questions||XSL Interview Questions|
|Xml Publisher Interview Questions|
Basics Of Xml
Basics Of Web Services
Introduction To Soap
Introduction To Uddi
Introduction To Wsdl
Creating A Web Service Using The Microsoft Soap Toolkit
Building Web Applications On The .net Platform
Creating An Asp.net Web Service
Creating A Web Service From An Interface
Introduction To The Atl Server
Creating A Web Service Using The Atl Server Library
Design And Creation Of The Knowledge Share Web Service
Introduction To Java Xml Technologies
Developing Java Web Services
Design And Creation Of A Web Service Using The Ibm Toolkit
Introduction To Mobile Applications
Creating A Mobile Application That Consumes A Web Service
Web Services Development With Jdeveloper
Creating Web Services Using Perl
Integration Of Xml Web Services With The Office Xp And Sql
Server 2000 Toolkits
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.