Database Programming
All contributors in Database Programming
How To Create an OpenOffice.org Database Log On
When looking an OpenOffice.org database there is no way of adding user accounts. Not directly, anyway. The secret is to use a little bit of SQL. more...
How to Create a Self Registering Base Database
With the release of OpenOffice.org 3.1 the programmer can do something important. They can add a macro to a database and they can run it automatically. more...
How to Create OpenOffice.org Database Macros
Release 3.1 of OpenOffice.org gives programmers a new facility - the ability to save macros as part of a database file. more...
How to Update A MySQL Database with C#
It is important to keep the contents of a database up to date. It's fortunate, therefore, that C# and the MySQL .NET connector make that an easy task. more...
How to Add Records to MySQL With C#
As well as viewing data in a MySQL database, a C# programmer can add information by using the SQL insert statement and the MySQL .NET connector more...
Connecting to MySQL from PowerShell
PowerShell is Microsoft's .NET scripting language. If the programmer combines this with the MySQL .NET connector then they can build a very powerful database application more...
Programming Inner and Outer Joins in a Query
SQL queries can extract data from single or multiple tables. How that data is extracts greatly affects what the programmer can obtains - and it all comes down to the join more...
All feature articles in Database Programming
Applying Referential Integrity to a Database
When not properly linked, badly connected tables can cause inefficiency to data retrieval. Eventually the database needs to be fixed by hand, at cost. more...
Transact-SQL Primer: Inner Join
By: Dan Hartshorn
A basic SQL concept that should be mastered is that of "joins." Joins allow for the display of data from different tables to be combined with specific relationships. more...
SQL Server Transact-SQL Primer
By: Dan Hartshorn
SQL programming is at the heart of today's Web 2.0 applications. Learn the basic 4 commands SELECT, UPDATE, INSERT and DELETE. more...
Install SQL Server 2005 Express
By: Dan Hartshorn
Ready to start programming SQL Server 2005? Here is a concise walk-through of the steps for obtaining and installing all the necessary software. more...
Programming MS Access Applications
An industry application written in Access 2007 is presented for inspection to learn how applications can be made more professional, using macros and VBA programming. more...
All contributing articles in Database Programming