The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

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.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Developing Re-usable Data Adapters in VS.NET

Abdul Al-Azzawe (abdulh@us.ibm.com), DB2 Tools architect, IBM

Abdul Al-Azzawe is the DB2 Tools architect for Visual Studio .NET. He joined IBM in 1990 and worked in the Toronto lab for ten years as part of the DB2 engine development team with special focus on the Windows platform. In March of 2000, Abdul joined the IBM Silicon valley lab to architect the release of the DB2 integrated SQL debugger, the DB2 Development Center, and the DB2 Development Add-Ins for Visual Studio 6.0. In May of 2002, Abdul joined the IBM San Francisco team to architect the integration with Visual Studio .NET, one of his proudest achievements in his career at IBM. Abdul has written numerous technical articles and tutorials for the DB2 Developer Domain covering a variety of DB2 application development topics. Abdul appreciates hearing feedback from actual developers about DB2 tools, and welcomes any suggestions for ways to improve these products.

Summary: The DB2 Stinger Development Add-In for Visual Studio Technical Preview technical preview takes ADO.NET RAD to new heights with the introduction of design-time reusable data adapters that enables both code sharing and re-use plus automatic Web methods and Web services code generation.

Date: 11 Nov 2003
Level: Intermediate
PDF: A4 and Letter (74 KB | 23 pages)Get Adobe® Reader®

Activity: 4795 views
Comments:

Before you start

About this tutorial

This tutorial demonstrates the power of the IBM Explorer's reusable data adapters, a new DB2 rapid application development (RAD) feature. To show the ease of building applications using reusable data adapters, this tutorial guides you through the steps required to develop components of a sample DADemo application using the DB2 "Stinger" Development Add-In for Visual Studio Technical Preview.

You will learn how to do the following from the IBM Explore:

Add local and remote DB2 data connections.
Create SQL procedures using a wizard.
Create reusable data adapters from existing tables and procedures.
Create reusable data adapters using a wizard.
Create reusable data adapters using existing component tray data adapters.
Define the result set shape of reusable data adapters including result sets for procedures.
Preview and update data for reusable data adapters.
Generate datasets for reusable data adapters and automatically generate data forms from data sets.
Export and import reusable data adapters.
Generate IIS WebMethods and deploy DB2 WebServices for reusable data adapters.

Should I take this tutorial?

This tutorial assumes that you are familiar with the concept of ADO.NET data adapters and data sets. The objective of this tutorial is not to build end-to-end application. rather, it is to build reusable components for future application development.

You should take this tutorial:

To learn about the new reusable data adapters' folder in the IBM Explorer.
To develop reusable data adapters for tables and procedures.
To share adapters across forms, projects, and users.
To generate IIS Web methods and deploy DB2 Web services for data adapters.
To learn more about the advanced features of the DB2 Development Add-In for Visual Studio .NET

Prerequisites

To complete the steps in this tutorial, you'll need the following software from both IBM and Microsoft: