(David Beulke) Walking down the street the other day, I found a $20 bill. Finding money (and, more commonly, finding ways to save it) never fails to please.
Author: SSWUG Research
MyODBC Connector – Part 1: Introduction
(Matthew R. King) This step-by-step tutorial takes the reader through the process of using databound controls in VB.NET using the MyODBC Driver to connect to a MySQL database. We will start by creating a very basic and simple MySQL database, then connect to it and bind controls from within Visual Ba
Convert Currency Values with a Custom Control
(Scott Lysle) This article describes the details for constructing a custom ASP.NET 2.0 composite control used to convert one form of currency into another. The control consumes a public web service in order to calculate the exchange rate and uses the exchange rate returned from the web service to ca
How to Add Data/Values for Corresponding Entries in a Combo Box Using Visual Basic .NET
(Sandeep Acharya) Most of the .NET developers used to experience a common problem while working with combo boxes. Generally, in a combo box or dropdown we used to store a value-text pair. For example, suppose we have an employee Table in a Database where we have a unique Employee ID for each employ
Getting to know the Atom Publishing Protocol, Part 2: Put the Atom Publishing Protocol (APP) to work
(James Snell) The previous installment in this series presented a brief walk-through of the Atom Publishing Protocol (APP). This article continues the introduction of the protocol by demonstrating how you can use it to interact with a number of real-world deployed applications.
Developing with Apache Derby — Hitting the Trifecta: Database development with Apache Derby, Part 7
(Robert Brunner) With this article you’ve reached an important point in mastering fundamental database concepts as they relate to the Apache Derby database. This article reviews how to modify an SQL query to group related rows together to provide summary statistics database information. Then it intr
Logging for security compliance in SQL Server
(Kevin Beaver) With all the government laws and industry regulations affecting business today, there’s likely no one in IT that’s unaffected by privacy and security compliance. Regardless of the governing body, a big part of compliance initiatives is to monitor activity related to sensitive informat
Achieve high availability with log shipping in SQL Server 2000
(Tim Chapman) In a recent article, I discussed some of the advantages and drawbacks of using SQL Server 2000 clustering as a high availability solution. While clustering is a useful high availability solution, sometimes it may be overkill, and it is very expensive. Database administrators can use lo
Integrating Oracle XML Publisher with Oracle JDeveloper 10g
(Deepak Vohra) In this article, you’ll learn how to use the FO Processor Engine, the XSL-FO Utility, and the PDF Document Merger. You’ll also get an overview of the Data Engine API, which generates an XML document from a database. The API uses an XML template to specify the SQL queries to the databa
Structured Exception Handling in .NET (ApplicationException)
(Arnaldo Sandoval) Everyone tries to write error free applications, but we all know end users are smarter than us, finding ways to break our well protected applications. Then we are given the answer “I don’t know” when we ask the obvious question “What were you doing?”, or “I can’t find it” to our