Log In
       Where ERP Meets the Web

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

This TechCrystals Code Package is a tutorial and working web pages source code bundle for the professional developer targeting use of c#, web forms, the MS .NET Framework and Db2 for i.  We also have two developer productivity tools that are available as optional add-ons to the base.  

In minutes, you'll be protyping all sorts of Db2 for i SQL within a web page, targeted to your latest Db2 for i features.  For developers new to c# or Microsoft "web forms", you can see how the results are produced by reviewing the c# source in the "code-behind" the html (or xhtml), in perhaps the least amount of code and html required.  The base package also includes everything you need to get IBM's Db2 for i .NET Provider downloaded and installed and configured.

Also available (priced separately) is a generic test harness for IBM SQL PL stored procedures with soft-coded parameter handling.  It is intended as a tool to work in conjunction with ACS Run SQL Scripts.  This add-on has increased modularity in the code-behind.  Add-On 1 is called SQL Prototyping Web UI and Stored Procedure Test Harness.

A second add-on, just released, known as Gen Db2 for i Stored Procedures and OO Wrapper Source,  allows gen of complete SQL PL stored procedures and c# and SQL PL stubs and snippets.  This add-on is a true development productivity tool that will help you significantly reduce repetitive and mundane facets when creating new stored procedures.   

With your purchase, you receive c# code-behind source that does the work behind the scenes to handle the SQL and stored procedure requests and that operates the web pages.  Along with some XHTML for the view...  A GridView, a UI control from the .NET Framework, provides the basis for the web page inquiry view, and it is populated dynamically based on columns in the SQL statement at runtime.  The column data lengths in the gridview are also based on the data returned at runtime, but are acheived via the gridview control and the features of HTML5.  There is a duplicate of the base and Add-On 1 web pages that operates within the responsive-bootstrap-master page strategy that is included in the base Microsoft Visual Studio project definition.  

In the event of errors in the SQL or stored procedure request (it happens when you're developing), quality diagnostic information is fed back to the UI and again you get the c# source code that does the work.  OK,  well, regarding the quality diagnostic feedback, the pretty nice c# code that is included gets a lot of help from the .NET framework runtime and IBM's DB2 for i .NET Provider (and Db2 for i).

Db2 for i capabilities come out of the Db2 for i version running in the targeted partition. 

We currently have Chapter (6) special circumstance specs involving the provider on free promotion! through July 31st, 2020, with your web user check in...  The info in this chapter is likely needed only when working with at least one of the following situations...   (a) Visual Studio 2015 and earlier versions  (b) 3rd party .NET languages (such as Visual RPG for .NET) or (c) the website project model. link to -> downloads page

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

Simplest Inquiry picture from Get Running - TechCrystals Code Package

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

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.  Similarly there is a good chance our package offers an increased productivity angle (at a good price point) for many developer skill and experience levels.  

The base version of Get Running - TechCrystals Code Package licenses for $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.  There is a second add-on that generates IBM SQL PL stored procedures and OO wrapper source stubs and templates for $210 which includes the first 6 maintenance term.

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 July 31st, 2020!**
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


If you want to take advantage of 15 years of Microsoft investment in an OO code base that supplements your web dev toolset, database integration efforts and IDE productivity, this is for you. 

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 TCP Add-On 1 (optional) - $195
(Ch 9)  (Add-On 1) SQL Prototyping Web UI and Stored Procedure Test Harness

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

Get Running - SP Test Harness with filtering via parameters


Get Running - SP Test Harness showing output parameters

Get Running TCP Add-On 2 (optional) - $195 + $40 annual support plan
(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)

More Technical Details on the Data Provider:  Licensing of this data provider from IBM is included with any 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 for use from websites or web applications in the Windows IIS web server.  No changes are required on Windows Servers at your company in order for you to use this product as a developer on your 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 let us know if you need information on earlier Visual Studio versions or Frameworks, or examples using the web site project model, or examples in vb.net or a 3rd party .NET language or something besides c# (for the code-behind).  Oh wait, that's Chapter 6!  Keep your eye out for times when we offer a free, no obligation PDF download of details. 

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



        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
800-739-3777
( please register or sign-in )
© 2009-2020 Tegratecs Development Corp.