 | Level: Intermediate Chenhong Xia (xia@us.ibm.com), User-Centered Design, IBM
22 Jun 2006
This is Part 3 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 required in the applications. Part 2 illustrated the steps of creating a Windows desktop application in .NET to consume the DB2 data. Part 3 will explain how to create a Web application in ASP.NET and wire the DB2 data to the Web application running in a browser.
Objectives
In this tutorial, learn how to wire DB2 relational data to a Web application in ASP.NET.
Prerequisites
This tutorial is written for application developers 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 basic concepts in relational databases and how to interact with database objects using ADO.NET.
System requirements
-
Windows operating system supporting Visual Studio .NET 2005
- Visual Studio .NET 2005 Professional edition or higher. This tutorial is developed using Version 8.0.50727.42, with Microsoft .NET Framework, Version 2.0.50727.
-
DB2 9. This tutorial is developed using DB2 9 Release Candidate. Download a free trial version of DB2 9.
Formats html, pdf
Tutorial overview
Part 1 of this tutorial series introduced a typical user scenario for developing a proof-of-concept application, called Carpool, for a company's employees to find other employees who live in the same city and drive around the same time. It discussed the application goals and design specifications. It also taught the steps of creating relational database objects in DB2, including tables, keys, index, view, trigger, and stored procedure.
Part 2 walked you through a typical scenario for creating a proof-of-concept Windows application called Carpool Application. The application is for employees in a corporation to find other employees to carpool. Learn how to create a Windows desktop application project and graphical user interface (GUI). Learn, also, how to connect to DB2 data source, bind to DB2 data, and present the data on the GUI.
Note: You may skip Part 2 (creating Windows application) of this tutorial series, if you are not interested in Windows desktop application and prefer to focus only on Web application. However, you need to finish creating the database objects explained in Part 1, in order to continue to Part 3.
In this tutorial, Part 3, go through a typical scenario for creating a proof-of-concept Web application, called Carpool Web site. The application is for employees in a corporation to find other employees to carpool. Learn how to create a Web application project in ASP.NET, lay out the graphical user interface, create a DB2 data source, bind the Web application to DB2 data, and present the data on the GUI running in a browser.
| | | |
