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 3: QuickStart Samples Accessing U2 Tables and Files Using IBM Data Server Provider for .NET

Access Rocket U2 Data Server from Your .NET Applications, Part 3

Page 1 of 8 Go to the next page

QuickStart Samples Accessing U2 Tables and Files Using IBM Data Server Provider for .NET

Fundamental examples of U2 data access using a .NET Windows application and the IBM Data Server Provider

Level: Intermediate

Ray Else ( relse@rs.com), Software Engineer, Rocket Software
Rajan Kumar ( rkumar@rs.com), Software Engineer, Rocket

29 May 2008

This quick start tutorial shows how both Windows® C# and VB.NET applications can access a UniVerse® or UniData® database using SQL commands or basic subroutines using the IBM® Data Provider for .NET. It covers defining the connections with or without connection pooling, and returning result sets or data sets, or XML or delimited data. Also, see how to use data readers, data sets, and XML. Furthermore, see how to call basic subroutines as stored procedures and pass parameters and get back parameter data. All .NET code and basic code is supplied, documented, and downloadable.

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 3 of a series of articles and tutorials that explore how you can increase productivity in accessing an 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. To see 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, refer to Part 2. This tutorial shows how, in a Windows C# or VB.NET application, you can pull data using SQL commands or native U2 data access commands. You will use SQL to select to a data reader and a data set. You will see how to call subroutines from .NET, passing parameters, and get back text or XML from tables or native U2 files.


 


Objectives

 

  • Explain the setup for using IBM Data Server for .NET in a Windows Application to access U2 databases
  • See coding examples in VB.NET and C#.NET of accessing U2 databases using IBM Data Server for .NET
  • See coding examples of making SQL select calls to get datasets
  • See coding examples of making U2 native basic subroutine calls to return data in various ways
 

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
  • Microsoft® Visual Studio 2005 or 2008, VB.NET or C#.NET, and ADO.NET

 


System requirements

The following should be installed and running on your machine:

  • 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

 

Page 1 of 8 Go to the next page
Document Actions