Skip to main content


developerWorks  >  Information Management  >

Develop proof-of-concept .NET applications, Part 2: Wire DB2 data to Windows applications

Create a Windows application in .NET using DB2 9

developerWorks

Level: Intermediate

Chenhong Xia (xia@us.ibm.com), User-Centered Design, IBM

15 Jun 2006

Register now or sign in using your IBM ID and password.

This is Part 2 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 explains how to create a Windows® desktop application in .NET and then wire the DB2 data to the application.

Objectives

In this tutorial, learn how to wire DB2 relational data to a Windows application.

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.

In this part, walk 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.

Share this....

digg Digg this story del.icio.us del.icio.us Slashdot Slashdot it!


Back to top


Document options

Document options requiring JavaScript are not displayed

Discuss


My developerWorks needs you!

Connect to your technical community


More in this series:
Develop proof-of-concept .NET applications