Skip to content. | Skip to navigation

Sections
Personal tools
You are here: Home Accelerate Tutorials Access Rocket U2 data server from your .NET applications, Part 2

Access Rocket U2 Data Server From Your .NET Applications Part 2

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.

Build the Next Generation Application Using UniVerse, UniData, IBM Data Server Provider for .NET, IBM Database Add-ins, and ASP.NET 2.0

Page 1 of 13 red navigation arrow

Rapid application development using IBM Data Server Provider for .NET and IBM Database Add-ins for Visual Studio

Level: Intermediate

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

14 Feb 2008

Before you start

Learn what to expect from this tutorial, and how to get the most out of it.

About this series

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

About this tutorial

For an overview on IBM Data Server Provider and IBM Database Add-ins, refer to Part 1 of this series. 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.

 

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.
  • Learn how to execute U2 native basic subroutines
  • Learn how to create a typed dataset and table adapter using U2 native basic subroutines.
  • Learn how to create custom Select, Insert, Update, and Delete statements from a U2 subroutine. You do not need SQL statements for Select, Insert, Update, and Delete. If performance is concerned regarding an update operation (using SQL commands), add the custom Update() method in the table adapter that executes U2 subroutine for the Update.

 

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

 

Page 1 of 13 red navigation arrow
Document Actions