(Steve Close) To complement the reports and inquiries provided by their standard ERP system, most iSeries shops use some kind of reporting tool to provide extra information to their users.
Author: SSWUG Research
Provider-Independent code simplified in ADO.NET 2.0
(Anthony Queen) This article will attempt to explain and demonstrate how Microsoft has simplified the approach to writing provider-independent code. Switching between Oracle, SQL, or any Oledb or Odbc data source is now as easy as setting a configuration setting.
What is an instance?
(Brian Peasland) What is an instance? Can we open more than one instance in a machine? (R)
Managing SQL exceptions in .NET applications
(Damon Armstrong) You can develop for obvious exceptions. Code reviews may catch some of the ones you missed. And your QA team can chip away at your application to uncover a lot more. But nothing exposes errors like deploying your application into production and letting real users give it a savage b
Toying with template parameters in SQL Server 2005
(Arthur Fuller) If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. Listing A is an example created by expanding the Programmability node in the o
A Visual Basic Developer’s Introduction to ASP.NET 2.0
(Scott Swigart) This article provides Visual Basic .NET and Visual Basic 6 developers with an introduction to building Web applications with ASP.NET 2.0. It focuses on the major differences between developing desktop applications and Web applications.
Database security: Options to protect data in SQL Server
(Kevin Beaver) With all the hype stirred up by high-profile database breaches and the dozens of privacy and security regulations, there’s a new how-to dilemma for SQL Server developers and DBAs coming on strong from owners. (R)
Standards and specs: XML: Half a standard is better than none
(Peter Seebach) The eXtensible Markup Language (XML) standard specifies a data format, but carefully leaves the question of what data is to be stored completely open. The storage format is immensely flexible, allowing for the representation of arbitrarily complex datatypes.
Working with Custom Error Pages Using ASP.NET
(Sanjit Sil) Every application should have error handling. We try to trap errors using try-catch-finally block. But what happens in the case of an unhandled exception in application? ASP.NET produces an error page (usually located at c:winnthelpiishelpcommon) when an application throws an unh
Building Tables with the DB2 Designer and Visual Studio 2005
(Paul Zikopoulos) In a previous series of articles I showed you all the great integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).