 | Level: Intermediate Ray Else , Software Developer, IBM
Rajan Kumar , Software Developer, IBM
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.
Objectives - Understand 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
Formats html, pdf
Tutorial overview
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.
| | | |
