Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Select a language:

  • Close [x]
  • Close [x]

Develop proof-of-concept .NET applications, Part 5: Create and consume Web services

Generate a Web service with one click

Farzad Farahbod, DB2 Developer, IBM
Farzad Farahbod photo
Farzad Farahbod is an advisory software engineer working at the IBM Silicon Valley Lab, providing tools for seamless integration with IBM servers. He is the Visual Studio .NET XML tooling lead.
Chat Chatterton (chat@us.ibm.com), DB2 Information Developer, IBM
Chat Chatterton photo
Chat Chatterton is an advisory software engineer at the IBM Silicon Valley Laboratory in San Jose, California. Chat is on the User Technology team, developing information for DB2 application development tools.
Chenhong Xia (xia@us.ibm.com), User-Centered Design, IBM
author photo
Chenhong Xia graduated from NMSU with a Ph.D. in Cognitive Psychology, specializing in human-computer interaction. She is currently working at IBM as a usability specialist for DB2 and Rational products. Chenhong is an IBM Certified Database Associate in DB2 Universal Database and a Microsoft Certified Professional in .NET. She is also UCSC-certified in object-oriented analysis and design. Her main interests include snowboarding, poetry, creative writing, and software architecture, with a zest for helping users understand IBM products.

Summary:  This is Part 5 of a tutorial series that teaches you how to create proof-of-concept applications to access relational and XML data in IBM® DB2® 9, using Microsoft® Visual Studio .NET® 2005. Part 1 explained the application specifications, database design, and how to create DB2 relational database objects that are required in the applications. Part 2 illustrated the steps for creating a Windows desktop application in .NET to consume the DB2 data. Part 3 explained how to create an ASP.NET Web application and wire the DB2 data to the Web application running in a browser. Part 4 described how to use the DB2 9 pureXML™ (native data store) for the application. This tutorial, Part 5, explains the steps for publishing a procedure as a Web service, and then consuming the Web service in a Windows application and a Web application.

View more content in this series

Date:  07 Dec 2006
Level:  Intermediate
PDF:  A4 and Letter (743 KB | 21 pages)Get Adobe® Reader®

Activity:  6471 views
Comments:  

Before you start

For application developers and DBAs, learn how to access DB2 data from the .NET development environment. This tutorial includes step-by-step instructions and screen captures.

About this series

This tutorial series includes multiple parts. The series introduces the specifications of a proof-of-concept application and its database requirements. It teaches how to create the relational database objects in DB2 9 using Visual Studio .NET 2005. It demonstrates how to wire DB2 with a Windows application. It also teaches how to bind the database objects with an ASP.NET Web application. It illustrates how to use the XML data store in DB2 9 to extend the application capacity. Finally, it illustrates how to leverage the DB2 data in Web services and the SOA environment.

Back to top

About this tutorial

This tutorial is Part 5 of the tutorial series. Go through the steps to create a Web service from a DB2 stored procedure to access DB2 data, and then consume the Web service in the Windows application that you built in Part 2, and the Web application that you built in Part 3 of this tutorial series.

Back to top

Objectives

In this tutorial, learn how to use DB2 9 and Visual Studio .NET 2005 to create and consume a Web service.

Back to top

Prerequisites

This tutorial is written for application developers and database administrators whose skills and experience are at a beginning to intermediate level. You should have a general familiarity with using the Microsoft Visual Studio .NET development environment. You should also understand Web services, and basic concepts of relational database, such as tables, views, triggers, stored procedures, keys, and referential integrity.

Back to top

System requirements

  • Windows operating system supporting Visual Studio .NET 2005.
  • Visual Studio.NET 2005 Professional edition or higher. The tutorial is developed using Version 8.0.50727.42, with Microsoft .NET Framework Version 2.0.50727.
  • DB2 9 (To download DB2 9, see the Resources section in this tutorial.)

1 of 10 | Next

Comments

Back to top

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=182140
TutorialTitle=Develop proof-of-concept .NET applications, Part 5: Create and consume Web services
publish-date=12072006
author1-email=ffarahbo@us.ibm.com
author1-email-cc=
author2-email=chat@us.ibm.com
author2-email-cc=
author3-email=xia@us.ibm.com
author3-email-cc=

Table of contents

1 of 10 | Next

Next steps from IBM

Tags

Help
Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).

My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

Use the search field to find all types of content in My developerWorks with that tag. Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere). My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

 

Dig deeper into Information Management on developerWorks

Try IBM PureSystems. No charge.

IBM PureSystems on a kaleideoscope background

Experience today!

Get started with the cloud-based trial and pattern development kit.

Share this page:

  • Close [x]

Follow developerWorks:

  • Close [x]