iSeries and System i Training
HOME >> Training Catalog >> Microsoft .NET for RPG Programmers (C# Version)
Microsoft .NET for RPG Programmers (C# Version) (CS05) Author: Craig Pelkie $495 Visual Basic Version of Microsoft .NET for RPG Programmers available here Gain Powerful iSeries Modernization Skills For a two minute overview of this training click play. Frequently asked questions for this training course

Remarkably easy to learn and use

One of the quickest and most effective ways to modernize your iSeries applications is to create web forms built using the Microsoft .NET framework. There's no need to scrap your iSeries investment, you can use the DB2 UDB database on the iSeries. Compared to some of the other modernization technologies, you'll find that the programming languages and tools used with Microsoft .NET are remarkably easy to learn and use effectively.

In this all new course, you'll quickly get up-to-speed with the tools, programming languages and development techniques that will let you create database driven applications in just a few short hours. Instead of spending a lot of time on boring examples that don't address business needs, you'll start creating database access code in your very first program.

As you create and run the programs, you'll quickly become familiar with the Microsoft Visual Studio development environment. Prior experience is not required, we'll show you exactly what you need to do to get your programs working. As soon as you complete one program, you'll use it as the basis for the next. With each program you complete, your skill and confidence will increase. You'll find that developing iSeries applications using C# is a comfortable and rewarding way to program, and is an excellent complement to your current RPG skills.

Here is what you will learn:

How to work in the Visual Studio development environment with solutions, projects, classes and other code files
• How to work with the code editor and use its built-in shortcuts to help you write bug-free code
• How to start and stop programs, and more importantly, how to set and use breakpoints in your programs
• How to use the IBM DB2 .NET Provider or the IBM OLE DB Provider to connect to your iSeries database
• How to quickly identify and resolve connection problems so that you can access your iSeries database
• How to handle exceptions and how to obtain detailed error information to pinpoint run-time problems
• Quick and easy techniques to develop test programs that display data...you'll be amazed at how quickly you can start seeing results, and pleased with how you can easily migrate code from your test programs to useful applications for production 
• How to use the iSeries Navigator tools to develop and test SQL, including stored procedures, and how to easily retrieve and modify the source code of an iSeries SQL stored procedure
• How to create a simple web application in minutes that will use your SQL statements to retrieve and display iSeries data...use this technique to create prototype web applications in minutes
• How to link list-type web displays to detail displays, to get the full functionality of subfile/detail type programming in your web applications

There's more . . .

Plus hundreds of other tips, techniques and examples that will help you learn how to work with Visual Studio, C#, SQL...and without making a big issue about it, you'll find yourself becoming comfortable with object oriented programming terms, techniques and practices as you work effectively with one of the most modern object oriented development environments

Once you see first-hand what you can do, you'll be ready to put your newly acquired skills and understanding to use. Many businesses are actively looking for development tools that will let them take advantage of their existing skill set, but provide them with powerful development options that don't take months to learn. By completing this training, you'll have an excellent understanding of the .NET option and how it can be used with your iSeries.

Prerequisites
(Required Hardware, Software and Skill Level)

IBM Hardware and Software:
IBM System i (AS/400, iSeries, i5) server running OS/400 V5R1 or later

Client Access Express V5R1M0 or
iSeries Access V5R2M0 or
iSeries Access V5R3M0 or
iSeries Access V5R4M0

Important note: even if your shop has not licensed iSeries Access from IBM, you still have access to the database components that are used in this course. IBM provides those important options free of charge to all OS/400 licensees.

- (optional, required for stored procedures examples) iSeries Navigator installed on your PC. This is a no-charge software product from IBM.

- (optional) DB2 Query Manager and SQL Developer's Kit (5722-ST1). This is a chargeable software product from IBM.

Microsoft Software:
Microsoft Visual Studio 2005 Professional Edition
Microsoft Visual Studio 2005 Standard Edition

Note: if you do not have a copy of Microsoft Visual Studio 2005, you can download a no-charge 90-day evaluation copy of Visual Studio 2005 Professional Edition from:

http://www.microsoft.com/vstudio/products/trial/

PC Operating System: (one of the following installed on your development PC)
Windows 2000 Professional (Service Pack 4)
Windows 2000 Server (Service Pack 4)
Windows 2000 Advanced Server (Service Pack 4)
Windows XP Professional (Service Pack 2)
Windows 2003 Server (Service Pack 1)

Important Note: You must obtain and install al required software for your System i and PC development environment. We do not and cannot provide copies of IBM or Microsoft software for your use.

Skill Level: Some experience with computer programming and database. Any RPG, COBOL or Java programmer with 1 or more years of experience will be able to successfully complete this course. This course is not intended for end-users or for novice programmers.

The course material provides an introduction to using Microsoft Visual Studio 2005 and Microsoft .NET technologies, with an emphasis on Console applications, web forms and ADO.NET techniques. Programmers who already have extensive Microsoft .NET experience will already be familiar with most of the material presented in this course.

Completion Time: Approximately 10 hours.

Download a free 90 day trial copy of Visual Studio

Get started today.

Visual Basic Version of Microsoft .NET for RPG Programmers available here