(Michael Bosch) Windows Forms databinding has greatly improved in .NET 2.0. Microsoft has enhanced our object-oriented toolbox by allowing Windows Forms controls to databind to our custom objects’ properties. This new functionality is centered around the new BindingSource component. Although this co
Other News
Take control and make better Web sites with ASP.NET 2.0 Web parts (Sample Chapter)
(Michael A. Kittel and Geoffrey T. LeBlond) Web Parts are the new building blocks of personalization in ASP.NET 2.0. A Web part consists of an ASP.NET server or user control that takes advantage of the Web Parts control set, which is a group of structural components found in ASP.NET 2.0. (pdf)
SQL Injections in PHP with MySQL
(Adam Plocher) SQL injections are a major security risk in many PHP applications. Injections are caused when a web developer allows the end-user to manipulate a variable that is being inserted into a database query string, generally through the $_GET, $_POST or $_SESSION superglobals. When a value i
Advance to Go
(Howard Fosdick) Have you considered taking IBM’s advanced DBA exam? IBM certified DB2 DBAs need only pass one test (#704) to attain the highest DB2 DBA credential.
Surveying Your Application Needs
(Raj Mattamal) As a product manager for Oracle Application Express (formerly Oracle HTML DB), I often want to gather feedback on workshops or training sessions I deliver. Using Oracle Application Express to quickly create surveys has proven to be so useful that I figured I’d write about it. Even tho
DSN-Less Connection to Oracle with ADO
(Kirby)This sample simply presents a message box indicating the Record Count to demonstrate a DSN-Less Connection. The sample included in the project documented in my Oracle Tutorial Web Site is more detailed and extensive.
Fetching the First Occurrence with SQL
(Bryan Watson) How can I fetch the first occurrnce of rows for each ID in my table?
Oracle 10g Scheduler Enhancements, Part 2: Job Chains
(Jim Czuprynski) One of the last projects I worked on as a software developer before I became an Oracle DBA was to implement a complex upgrade to several stored procedures within my client’s DB2 database so that a new set of accounting rules could be applied to their commodities management applicati
Wrapping Your Brain Around Oracle + Python
(Catherine Devlin) PL/SQL is ideal for programming tasks within Oracle Database. Most Oracle professionals, however, aren’t confined to working strictly within the database itself. You’ve probably encountered many tasks for which PL/SQL has proven clumsy or even unusable—such as manipulating files o
Error Handling in SQL Server – a Background
(Erland Sommarskog) In many aspects SQL Server is a very good DBMS that permits you implement powerful solutions with good performance. However, when it comes to error handling… To be blunt: error handling in SQL Server is poor. It is a patchwork of not-always-so-consistent behaviour. It’s als