Before you start
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
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.
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
To complete the steps in this tutorial, you'll need the following software from both IBM and Microsoft:
- IBM DB2 V8.1.2 Application Development Client
- DB2 "Stinger" Technical Preview
- IBM DB2 V8.1 Server
- IBM DB2 SAMPLE database
- Microsoft Windows 2000, 2003, or XP with the Microsoft .NET framework V1.1
- Microsoft Visual Studio .NET 2003