Log In
       Where ERP Meets the Web

Get Running - TechCrystals Code Package

Get Running with the IBM .NET Data Provider and Db2 for i

Get Running with IBM .NET Data Provider and Db2 for i

This product is a tutorial, presentation and web page source code bundle for the professional developer.

We currently have Chapter 3 on promotion for free through October 25th 2019 with your

You'll be off and running with an SQL prototyping capability against your Db2 for i database.  The latest database features and SQL syntax will be available to you based on the Db2 for i version running in the target partition. 

In response to your SQL select statement, a nicely formatted grid inquiry result is returned in the form of an .aspx web page.  Well, unless there are errors in the request.  In that case, quality diagnostic information is fed back on the web page.

The source is c# code-behind along with some XHTML for the view.  A GridView (a UI control from the .NET Framework) provides the basis for the web page inquiry, and it is populated dynamically based on columns in the SQL and column data lengths at runtime.   

(5) Simplest and fastest inquiry method (pictured)

Simplest Inquiry picture from Get Running - TechCrystals Code Package

Please note this particular Db2 data provider is dependent upon the Microsoft .NET Framework.  A key point however, is that there is top-notch leveraging of both .NET Framework features and IBM Db2 happening here, so as a developer, you get lots of power at your disposal and a great tool to have in your arsenal.  

Obviously much of the technique you use and SQL and stored procedures (add-on) prototyping you do in working with this can be applied to your efforts in developing custom production software or ad-hoc queries for end users at your company.  

The base version of Get Running - TechCrystals Code Package licenses for only $295 (for individuals or end user companies).  There is an optional add-on to the base that allows you to run and test stored procedures with parameters for $195.

Get Running - TechCrystals Code Package (base)
(1) install VS 2017 CE or VS 2019 CE pics
(2) create c# web app (web forms) base project VS 2017
(2) create c# web app (web forms) base project VS 2019
(3)  download latest Db2 for i .NET Data Provider from IBM
**complimentary with registration through October 25th, 2019**
(4) install latest Db2 for i .NET Data Provider DLL
(5) create new web project - simplest and fastest inquiry method
(5) subset - enable use (reference) the DLL in an existing VS project
(6) special circumstance specs involving the provider
(7) (bonus) Simplest Inquiry using supplied responsive master page
Get Running with the IBM .NET Data Provider and Db2 for i presentation powerpoint

(7) Simplest Inquiry using supplied responsive master page (pictured)

Simplest Inquiry with responsive master page picture from Get Running - TechCrystals Code Package

Get Running TCP Add-On 1 - $195 (optional)
(9) Advanced Inquiry with option to run an SP with parameters

(9) Advanced Inquiry with option to run an SP with parameters (pictured)

Simplest Inquiry with responsive master page picture from Get Running - TechCrystals Code Package


Simplest Inquiry with responsive master page picture from Get Running - TechCrystals Code Package

Get Running TCP Add-On 2 - $195 (optional) (sorry, not yet available, coming soon)
(21) Generate Stored Procedure and c# wrapper base function source templates based on Db2 for i metadata

Get Running - Licensed Product Downloads (and occasionally a promo or two)

Didn't find what you were looking for?  Please let us know. 

More Technical Details on the Data Provider:  Licensing of the data provider from IBM is accomplished via the IBM ACS (Access Client Solutions) license.  The data provider is an IBM product that is not distributed in this TechCrystals Code Package.  However, this product bundle includes a rather complete set of information on how to source the latest version of the provider, and how to install it on the Windows workstation (for use in Visual Studio) and the Windows server (when going to production).  No changes are required on Windows Servers for use of this product bundle by the developer on his/her workstation.  Obviously at least one IBM i user profile is required for access to Db2 for i.  Connection string example shows how to use the *LIBL technique...  Please note that download of the data provider and its setup.exe is done separately from the base ACS (Access Client Solutions) and is done by downloading the Windows Application Package (typically called something like  IBMiAccess_v1r1_WindowsAP_English).   

Please ask us about a VB.NET version of the code-behind the web page if that is your interest. 

Get Running - Licensed Product Downloads (and occasionally a promo or two)

If you have an ASNA AVR for .NET license and you would like a version of the source code in Visual RPG for .NET instead of c#, we can probably whip that up pretty quickly too.  In the AVR language, use of SQL or stored procedures with the data provider and its data adapter implementations makes a nice complement to record-level-access and offers you additional flexibility in getting the job done in the most efficient manner without going to c# or vb.net language components.  Please note, however, AVR for .NET uses the web project structure, so you can have c# and vb.net components in the project and they are supported in both the App_Code directory and web pages.   




        go to the home page     go to next series page Next in TechCrystals Code Packages     Site Map     Switch to
Mobile View

You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Integrity, Integration and ROI from Your Software
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )
© 2019 Tegratecs Development Corp.