Building an ASP.NET 2.0 Master/Detail Application With DB2
Building the Application
Launch Visual Studio 2005, and then create a new Web site. Choose either C# or VB. Next, switch to design view, and then drag and drop a GridView Control and a Details View Control onto the Web form. Your application should now look like the one shown in Figure 1.
Figure 1: Web Form of Your Demo Master/Detail Application
Next, you configure the data source for your Grid View and Details View. Click on your Grid View Control and under Data Source choose New Data Source. Select Database and name it MasterDetail. Click OK.
Configuring the Details View
You now will see a dialog in which you need to specify an existing connection to a DB2 database. Click next and name this connection MasterDetailconString. Click Next. (Note: The DB2 Connection Wizard is being replaced and added to the Server Explorer to help maintain consistency when connecting to a variety of databases.) Now you will be asked to choose the table from DB2. Select DEPT table and click on the asterisk (*) checkbox to display all records. Finally, click Finish.
Configuring the Grid View
Follow the same steps for configuring the Grid View, except when you come to the screen where you chose DEPT as your table, click on the WHERE button instead. You need to modify your SQL statement with the following options in order to display the appropriate employee that belongs to a particular department:
- Column: DEPTNO
- Operator: =
- Source: Control (This enables you to choose GridView1 as your source control for retrieving the appropriate employee information.)
- Control ID: GridView1, and then click the Add button to complete the SQL query expression.
Figure 2 shows the WHERE clause with all the correct selections.
Figure 2: WHERE Clause With All the Correct Selections
Click OK and Finish, and your Grid View will be ready to go. You may want to auto-format it as well as your Details View for a better presentation.
You now have both your views configured, and you are ready to run the application. Your final application will look like the one shown in Figure 3.
Figure 3: Your Final Demo Master/Detail Application
Run the application by pressing F5. You should be able to view the final application as shown in the browser in Figure 4.
Figure 4: Browser View of Your Final Demo Master/Detail Application
Now wasn't it easy to work with DB2 using ASP.NET 2.0?
About the Author
Anil Mahadev is a DB2 enthusiast and DB2 India User Group Lead Logo Architect. Send him your feedback and comments at firstname.lastname@example.org.
Page 2 of 2