PBDJ Feature Story
There's a lot of "legacy" PowerBuilder code that you might want to access
from .NET applications or perhaps PowerBuilder has some superior
functionality that you would like to make use of in a .NET application. Think
about how easy it would be to create a report in PowerBuilder with a
DataWindow. Of course, PB can provide functionality through Web Services (see
my article "Prognos with DataWindow.NET 2.0 and PowerBuilder 11 Web Services"
in PBDJ some time ago) but this has its limitations.
In the article "PowerBuilder 11's .NET Interoperability" in PBDJ, John Strano
showed briefly how to use a PowerBuilder assembly in .NET. This article
demonstates how to create a PowerBuilder assembly and elaborates on how to
reuse this assembly in C# projects. First, I will start with a simple console
application, then go over to an ASP.NET page and finish with ... (more)
So you think, "Why bother using PBDOM?" Well, you can use PDOM to manipulate
elements in an XML document. That means you can move elements in a document
or from one document to another. You can add elements to a document or delete
them from a document. And, with a little coding, you can import nested XML
data into a DataWindow.
With the XML capabilities in the DataWindow introduced with Sybase's
PowerBuilder 9, it's possible to import and export data very fast and easily.
You might have glanced at the PBDOM definition in the PowerBuilder help and
figured it looked hard to handle... (more)
Prognos is an application used over the Internet to determine if it makes
sense to apply for a scholarship. It's part of a program package used in a
couple of cantons (the equivalent of a state in the U.S.) in Switzerland to
manage applications for a scholarship.
The current version runs with DataWindow.NET 2.0 and uses PowerBuilder 11 Web
Services. To keep the installation slim it uses no database; instead the data
is stored in DataWindows or XML files. Prognos makes use of AJAX techniques
and accesses .NET classes from PowerBuilder for XML handling. Since it's used
in Switzerl... (more)
Last year I wrote an article in PBDJ describing an ASP.NET project that was
done with DataWindow.NET in the browser ("Prognos" Volume 14, Issue 4) and
PowerBuilder Web Services in the back end. The front end consisted of an
intro page, two data entry pages, and one page with the result.
The front end was rewritten in a couple of other technologies to test
different ways to create browser-based applications. This article covers
solutions that run in different browsers and on different operation systems.
I will also look at PowerBuilder 11.2 Webform although it is IE-only. At the
PowerBuilder TV hosts regular webinars to PowerBuilder related topics and
will broadcast its first session on April 8th at 10 am EST.
Arthur Hefti will present "Using PowerBuilder Assemblies with .NET" on
PowerBuilder TV June 15 2pm CET.