Log In
       Innovative Solutions for Your Evolving Needs

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 targeting use of Db2 for i SQL in the Visual Studio IDE, or production IIS web server.

There are also two optional add-on components that help boost productivity for developers already working with stored procedures, so please see below 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 (so 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).  For column headings, you get nice dynamic formatting, and you can pull from whereever 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.

SQL Prototyping Web UI and Stored Procedure Test HarnessAdd-On 1 is a generic test harness for IBM SQL PL stored procedures.  It allows the developer or technical consumer to quickly and dynamically see input and output parameter lists and results sets for Db2 for i stored procedures in HTML5, with nice dynamic sizing of long data elements...  For example, changes made to the stored procedures metadata by another developer in a separate session of ACS are used immediately.  Dynamic row filtering on top of the result set is also available. 

When you consider the other features within this offering, it makes it a contender as your best development tool for prototyping Db2 for i stored procedures regardless of whether they will be consumed by a .NET programming language in a web, client-server or hybrid environment or by a native IBM i programming language.  The less capable the language or the UI integration, the more this tool makes sense. 

Between the .NET Framework and c#, null is supported as a parameter value in this environment, and our tool lets you indicate a null input parameter via entry of the keyword "*null".  Add-On 1 also features increased modularity in the c# code-behind. 

Add-On 2 is Gen Db2 for i Stored Procedures and OO Wrapper Source.  It allows gen of complete IBM SQL PL stored procedures and c# and SQL PL stubs and snippets.  While you'll still have to compile the stored procedures somewhere (like ACS), Add-On 2 is a true development tool. 

Add-On 2 is intended to help you formulate large column subset lists or to build or enhance views and stored procedures from inline SQL, including those with joins, or from stored procedures with simlar results sets.  Column attributes are pulled from Db2 metadata.  This tool will help you significantly reduce repetitive and mundane facets and save a lot of whittling (and in some cases, column reference mispellings).  It even does lookups within the runtime library list to find the appropriate attributes for column names with suffixes, which are created by the gridview to resolve duplicates resulting from join statements that select all columns. 

This product also goes a long way with helping you with how-to examples and ideas and angles for problem-solving technique, because there are so many types of stubs and snippets that are output with each input.  Nicely-formatted SQL column headings with spaces are supported.  Please see pictures of example output for Add-On 2 in these pages. 

With your purchase, you'll receive all of the c# code-behind source that does the work behind the scenes to set up the SQL and stored procedure requests and that operates the web pages.  Along with all of the XHTML and CSS used for the views... 

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 you can deploy Add-On 1 for users...  See Chapter 7 picture below...  The 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, what you might need is in there.

(Chapter 5) Dynamic Inline SQL to Results Gridview (web page) (pictured)

Simplest Inquiry picture from Get Running - TechCrystals Code Package

While this particular Db2 data provider from IBM is dependent upon the Microsoft .NET Framework, this often enables top-notch leveraging of both .NET Framework features (web and infrastructure) and IBM Db2 within your programming language, so as a developer, you get lots of power at your disposal.  

Get Running - TechCrystals Code Package (base)
(Ch 1) install VS 2017 CE or VS 2019 CE pics
(Ch 2a) create c# web app (web forms) base project VS 2017
(Ch 2b) create c# web app (web forms) base project VS 2019
(Ch 3) download latest Db2 for i .NET Data Provider from IBM
(Ch 4)
install latest Db2 for i .NET Data Provider DLL
(Ch 5a) create new web project - simplest and fastest pro app
Dynamic Inline SQL to Results Gridview (web page)
(Ch 5b) subset - enable use (reference) the DLL in an existing VS project
(Ch 6) special (rare) circumstance specs involving the provider
(Ch 7) simplest and fastest pro app with responsive master page from MS project template
Chapter (6) special (rare) circumstance specs involving the provider
**complimentary with registration through February 28th, 2021!**
link to -> downloads page


(Chapter 7) (pictured) Simplest and Fastest Pro App with responsive master page from MS project template (included in base)

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

Obviously much of the technique you use in working with the Get Running - TechCrystals Code Package™ can be applied to your efforts in developing custom production software or ad-hoc queries for end users at your company.  Similarly there is a good chance our package offers an increased productivity angle (at a good price point) for a variety of developer skill and experience levels.  



Get Running TCP Add-On 1 (optional)
(Ch 9)  (Add-On 1) SQL Prototyping Web UI and Stored Procedure Test Harness

(Chapter 9) (3 examples pictured)
(Add-On 1) SQL Prototyping Web UI and Stored Procedure Test Harness

The Add-On-1 component is generic test harness for IBM SQL PL stored procedures, with soft-coded parameter handling.  The work is done via a single c# .aspx web page, c# code-behind, a couple of classes and the data provider.  The default presentation of Add-On-1 in v2.1 is no longer implemented within a responsive master page so you can expand to get giant width over multiple monitors on the destop based on data at run-time.

Get Running - SP Test Harness with filtering via parameters


Get Running - SP Test Harness showing output parameters

Add-On 1 example, but customized with a user-friendly list of stored procedures
(note: Row Filtering at run time on "Bumblebee" takes results down from 80 rows to 0 rows as no one is named "Bumblebee" at least yet)
Get Running - SP Test Harness customized example


Get Running TCP Add-On 2 (optional)
(Ch 21) Gen Stored Procedure and c# wrapper base function source templates and stubs based on Db2 for i metadata

Get Running - SP Test Harness with filtering via parameters


Get Running - SP Test Harness showing output parameters


link to GR-TCP2 Example 1 full browser page snapshot PDF

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)

Running Framework 3.5? No problem.  We currently have Chapter (6) special circumstance specs involving the provider on free promotion! through February 28th, 2021, with your web user check in...  The info in this chapter is likely needed only when working with at a combination of the following situations...   (a) Visual Studio 2013 and earlier versions,  (b) 3rd party .NET languages (such as Visual RPG for .NET), (c) the website project model or (d) earlier versions of the data provider. 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...
Innovative Solutions for Your Evolving Needs
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )
© 2020 Tegratecs Development Corp.