Video Programming for IT Professionals
Author: SSWUG Research
MySQL Logon trigger
(Oli Sennhauser) With MySQL 5.0 the database provides trigger functionality on INSERT, REPLACE, UPDATE and DELETE. (pdf)
DataGridView vs DataGrid
(Russ Sabitov) The DataGridView Windows Forms control is a quite new .NET control introduced in MS Visual Studio .NET 2005 that is a good alternative to the VS .NET 1.x DataGrid control. The data table presentation feature became much easier to be implemented in .NET Windows application.
A beginners guide to XPath
(francisg2005) This article aims to explain what an XPath expression is and why they can be extremely useful to a C# programmer.
Adding some colour to SQL*Plus
(Andy Campbell) Here is a quick tip that I’ve found useful for enhancing my SQL*Plus reports and scripts …
ExecuteWithParams in your Oracle ADF application
(Andrejus Baranovskis) Recently I was researching Google Analytics data for my blog. I have noticed, that there are many search engine keywords with ‘ExecuteWithParams’ word. Really, this action plays one of the central roles in Oracle ADF BC application, it is used quite frequently and people want
How to Create Microsoft Access DataSource for Win Forms App Visual Basic 2005
(Mike McIntyre) Visual Studio 2005 provides a feature, the ‘Data Source Configuration Wizard’, for creating a DataSource for a Windows Forms 2.0 application. This article provides step-by-step instructions and a sample Visual Basic 2005 application you can use to learn how make a Microsoft Access da
A revision to my personal opinion/observation on the performance of DB2 V8 Multi-row FETCH
(Willie Favero) It’s raining this dreary Saturday morning in Houston so I’ve decided to post a revision to one of my previous post that I made this week. Because I am now “working”, I’m hoping this gets me out of hanging pictures today. (Isn’t it kind of strange that both of my recent posts on multi
Using advanced table hints in SQL Server
(Tim Chapman) My previous SQL Server column covered two types of table hints: NOLOCK and READPAST. This article explores the advantages and drawbacks of using three other types of table hints when running queries in SQL Server: READCOMMITTED, REPEATABLEREAD, and SERIALIZABLE.
Manage Microsoft Office 2007 documents with DB2 9 pureXML
(Chris C. Gruber) Integrate your Microsoft Office 2007 documents into your enterprise and Internet applications more easily than ever before with DB2 9. Review older methods of data interchange with MS Office documents, and learn how MS Office 2007 offers better data interchange. This article discus