Access IBM U2 data server from your .NET applications, Part 2: Build the next generation application using UniVerse, UniData, IBM Data Server Provider for .NET, IBM Database Add-ins, and ASP.NET 2.0

Level: Intermediate

Rajan Kumar , Software Developer, IBM
Brent Gross (gross@ca.ibm.com), .NET Architect for IBM Data Servers, IBM

14 Feb 2008

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

The goal of this tutorial is to show UniVerse® and UniData® (U2) application developers how to develop a next-generation, master-detail ASP.NET Web application, Web service, and ASP.NET Crystal Report using IBM® Data Server Provider for .NET and IBM Database Add-ins. For U2 users, the master-detail relation plays an important role, as it is related to multi-value and multi-subvalue concepts. In the past, it was difficult to create a master-detail (multi-value,multi-subvalue) relation using Grid Controls, but now with ASP.NET 2.0 and Visual Studio, you can develop U2 Web applications without writing a single line of code. For an overview, refer to Part 1 of this series.

Objectives

• Create a UniVerse and UniData data access layer (DAL) and BLL for a three-tier architecture application.
  
  
• Build a master-detail, data-driven ASP.NET Web application with the use of GridView, FormsView, and DetailsView controls.
  
  
• Build an ASP.NET Crystal Report Web application.
  
  
• Create and consume ASP.NET Web services from U2 tables and subroutines.
  
  
• Execute U2 native basic subroutines.
  
  
• Create a typed dataset and table adapter using U2 native basic subroutines.
  
  
• Create custom Select, Insert, Update, and Delete statements from a U2 subroutine.
  

Prerequisites

U2 is no longer an IBM brand In October 2009, the U2 products became products of Rocket Software.

To complete this tutorial successfully, you need a basic understanding of:

• UniVerse 10.2 or later and UniData 7.1 or later databases
• IBM Data Server Provider for .NET and IBM Database Add-ins
• Visual Studio 2005, ASP.NET, ADO.NET, Web Service, and Crystal Report

System requirements

• Windows operating system supporting Visual Studio
• UniVerse 10.2 or later and UniData 7.1 or later databases
• Microsoft Visual Studio
• IBM Data Server Provider for .NET and IBM Database Add-ins

Duration

Formats

Tutorial overview

This tutorial is part of a series of articles and tutorials that explore how you can increase productivity by accessing a IBM U2 data server from your .NET applications.

Microsoft ASP.NET is a technology that allows application developers to create dynamic Web applications. ASP.NET is a part of the Microsoft .NET framework, and a powerful tool for creating dynamic and interactive Web pages. This tutorial describes the benefits of using U2 databases with ASP.NET's master-detail capability to build a Web site.

Visual Studio Server Explorer Integration allows Application Developer to develop a master-detail ASP.NET Web page without writing a single line of code. It shows how you can create a typed dataset and custom Select, Insert, Update, and Delete statements using U2 subroutines and tables. It shows how to map an ASP.NET ObjectDataSource's Select(),Insert(), Update(), and Delete() methods to the methods of business logic layer (BLL) classes, which in turn points to U2 subroutines. U2 Application Developer can easily take advantage of UniVerse and UniData's TOXML capability and XMLExecute() basic routines to fetch XML data and convert into a typed dataset.

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

Back to top