 | Level: Intermediate Rajan Kumar (rajank@us.ibm.com), Software Developer, IBM
Brent Gross (gross@ca.ibm.com), .NET Architect for IBM Data Servers, IBM
14 Feb 2008
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
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 html, pdf
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.
| | | |
