Log In
       Innovative Solutions to Your Evolving Requirements

Get Running - TechCrystals Code Package™

Get Running with the IBM Db2 for i .NET Provider

Get Running with the IBM Db2 for i .NET Provider

The base product for this TechCrystals Code Package is a fast-path tutorial and working web pages source code bundle for the business software developer wanting to target a Db2 for i database from an OO language, Microsoft .NET framework environment.

There are also two optional add-on components that help boost productivity for developers already working with IBM SQL PL stored procedures (or  planning to), so please click here for that...  

Within minutes, using just our base product, your Db2 for i database and any version of the Visual Studio IDE, you'll be protyping all sorts of dynamic SQL within a zero-footprint web page (runs within most any browser without any add-on requirements).  And you'll have the capability to tap into the latest Db2 for i features on your IBM i Power System.  For developers somewhat new to c# or Microsoft "web forms", you will be able to see and enjoy how results can be produced in a GridView using a minimal amount of c# in the "code-behind" the html (and xhtml in the case of the GridView).  We also have a vb.net version in the base package coming with the v2.2 release (vb.net version to be included for download to those with earlier purchases at no extra charge).

There is a free license of the vb.net versions being given to people who attend our Get Running with the Db2 for i .NET Provider session at POWERUp 2021.  Virtual attendance counts if we see your smiling face!

For column headings, you get nice dynamic formatting, and you can pull from wherever and however in order to get your user-friendly column headings out from under the covers, such as by pulling from views, physical files, logical files or even SQL field renaming syntax.  Incidentally, column duplicates created via dynamic joins without discreet column lists are resolved automatically in the GridView control (yea!).  This makes it a little challenging in Add-On 2, but more on that later.  

The base package also includes everything you need to know to get IBM's Db2 for i .NET Provider downloaded and installed and configured in a ASP.NET OO web forms project for your desktop (with Visual Studio, even Community Edition) or for production in an IIS web server.  Although the example usages includes are done within web pages, the provider techniques can be used within other VS project models such as client-server.

With your purchase of the base, you'll receive all of the c# (and equivalent vb.net) code-behind source that does the work behind the scenes to set up the SQL requests and that operates the web pages.  Along with all of the XHTML and CSS used for the views...   To prototype stored procedures, please see Add-On 1.  To get help with generating SQL PL stored procedures from SQL statements including those with joins, please see Add-On 2

Bootstrap or Not - No Biggie
There is a duplicate of the base and Add-On 1 web pages that operates within the responsive-bootstrap-master page strategy, since bootstrap is a part of the web application .NET Framework project template supplied in Visual Studio and it might make sense for you to put out a version of Add-On 1 for users...  See Chapter 7 picture below of the responsive page within the base package...  Another reason we offer it as a duplicate is to accomodate your current shop's strategy and to enable you to easily isolate the differences.  But it turns out that tweaking some of the CSS properties in a generic run-time gridview is a bit of a hassle when using bootstrap because you have to get to the required level of specificity for the properties to take...  Anyway, even what you only might need is in there.  LOL

(Base - Chapter 5) Dynamic Inline SQL to Results Gridview (web page) 1st example - Shown here with simple SQL statement going against a View

Dynamic Inline SQL to Results GridView picture from Get Running - TechCrystals Code Package

vb.net versions to be included in the base package very soon!  downloads access to the new vb.net chapters will be provided to those who have already purchased...  

Purchase now to save price increase...

Get Running - TechCrystals Code Package (base)
(Ch 1) install VS 2017 CE or VS 2019 CE pics
(Ch 2) create web app (web forms) base project
(please follow either c# or vb.net path)
   (a)     c# Visual Studio 2017
   (b)     c# VS 2019
   (c)     vb.net VS 2019
(Ch 3) download latest Db2 for i .NET Provider from IBM
(Ch 4)
install IBM Db2 for i .NET Provider DLL
(Ch 5) add new web page - Dynamic Inline SQL to Results GridView
   (a)     c#
   (b)     vb.net
(Ch 5x) (all languages) - enable use (reference) the DLL in an existing VS project
(Ch 6) special (rare) circumstance specs involving the provider
(Ch 7) add new mobile-friendly web page inquiry via responsive master page
   (a)     c#
   (b)     vb.net
(Ch 8)
drag and drop PF as an External DS to create OO DataSet
Need a freebie chapter to help you decide whether to purchase?  Let us know!

(Base - Chapter 5) Dynamic Inline SQL to Results Gridview (web page) - 2nd Example - Db2 for i metadata query showing a subset of files within the library list along with some system versus table naming differences... 

Dynamic Inline SQL to Results GridView listing a subset of file namnes but only within the library list

(Base - Chapter 5) Dynamic Inline SQL to Results Gridview (web page) - 3rd Example - Showing both SQL filtering and GridView filtering along with Db2 for i SQL timestamp formulation at run time from old style decimal date and time columns... 

Dynamic Inline SQL to Results GridView demonstrating 2 types of filtering and timestamp formulation (from decimal fields)

(Base - Chapter 7)  Dynamic Inline SQL to Results Gridview with responsive master page (responsive master page is included in base MS project template) - Shown here with SQL that lists out the user libraries on the library list.

Dynamic Inline SQL to Results GridView with responsive master page demonstrating SQL to list out the user library list

Obviously much of the technique you use in working with the Get Running - TechCrystals Code Package™ base package can be applied to your efforts in developing custom production software or ad-hoc queries for end users at your company.  It is also an excellent tool for prototyping data formats quickly for developers using Microsoft OO languages and the .NET Framework 4.8.  For even more increased productivity angles for a variety of developer skill and experience levels, please see the Add-On packages, available separately.  

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

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

We currently have Chapter 2c - create web ap (web forms) base project (vb.net VS 2019) on free promotion through November 15th 2021 with your web user check in...    link to -> downloads page

        go to the home page Top of TechCrystals Code Packages     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
( please register or sign-in )
© 2021 Tegratecs Development Corp.