In this article, we're going to look at how DataWindow.NET technology is a
simpler but more powerful way of formatting data in the presentation layer.
We'll be taking a sample application provided by Microsoft for .NET and
implementing it using DataWindow.NET technology. In this case, we're using
the Visual Basic .NET Code Sample: DataGrid Formatting sample application
available at www.microsoft.com/downloads/details.aspx?
The original sample was written to connect to the Microsoft Northwind sample
database. So you'll need MSDE or SQL Server with that sample database
installed if you want to try it out for yourself. Also like last month's
article, the sample code for this article is intended as an addition to the
original sample so you can compare them side-by-side. After adding the sample
code files from... (more)
If you're familiar with the Database Binary / Text Large Object column type
in PowerBuilder Classic (see Figure 1), you know it's a way of storing blob
data associated with an OLE Automation application (Paint, Microsoft Word,
Microsoft Excel) and then displaying it as part of a DataWindow.
There were some limitations with the Database Binary / Text Large Object. It
required the end user to have the application that was used to add the object
to the database in order to view the data. It often didn't display the data
well within the DataWindow. And it wrapped the data stored in th... (more)
Oracle was slow to introduce support for returning result sets from stored
procedures. When they finally did add such support, they did so in a manner
that was somewhat different than the approach used by other vendors.
This has a couple of consequences for PowerBuilder developers. The first is
that the PBDBMS approach was developed within PowerBuilder as an interim
workaround. The second is that using stored procedures to return result sets
is not as widespread a practice with Oracle databases as it is with other
This article (an excerpt from an upcoming book ... (more)
Last month we looked at Microsoft's .NET Pet Shop sample application and saw
how DataWindow.NET technology could be used in the data access layer of an
ASP.NET-based application to reduce the its complexity and increase developer
This month we'll look at another Microsoft sample application to see what
benefits DataWindow.NET technology can provide when used for data
presentation and data access in a Windows Forms (WinForms) application.
To fully appreciate how much DataWindow.NET simplifies the development of
database applications in Windows Forms, you'll need the ... (more)
Sybase's Adaptive Server Anywhere (ASA) is a small footprint, low maintenance
database designed for mobile, embedded, personal and workgroup settings. In
spite of its compact nature, it still provides all the "big iron" features,
such as replication, synchronization, and Java in the database.
It is also a very flexible database, which makes it highly suitable for use
in the development of prototypes for applications that might eventually be
implemented in other database systems. Finally, it's the one database that is
provided with PowerBuilder (a single-user license that can be up... (more)