Database Access Protocols
One of the first decisions that a programmer has to make in using a database is which 'access protocol' to use. This early article (1999) covers some of the older protocols. About Exclusive - SQL Fundamentals Best of the Net
You don't need to know everything about SQL, the Structured Query Language for databases, to write a database focused Visual Basic system, but you probably should know something. This great article gets you started!
About Exclusive - ActiveX Data Objects Best of the Net
ActiveX Data Objects - ADO - is the future of Microsoft's data strategy and therefore a key technology for most VB programming Check out this excellect About Guide to this important new technology. About Exclusive - ADO Data Connection Best of the Net
This is a followup to the ActiveX Data Objects article at About.COM. The use of a data connection is one of the most important techniques in using ADO. This article fills in the details. About Exclusive - Normalizing Databases
Once you get past database basics (or even before ... it's never too soon to learn the right way), you need to know something about "normalization". That's tech-speak for an systematic way to make your database designs as good as they can be. The About guide to normalization is available in four complete articles. Joining SQL Tables
Getting information out of SQL databases often requires that you "join" several tables using common data. This great article tells you about the types of joins that you can perform and how to do them. Getting Started - Early VB Supported Databases
A good basic tutorial that covers Microsoft Jet, and Data Access Objects (DAO). Using these objects, you can create databases and build applications that access Microsoft Access, Btrieve, dBASE, Microsoft FoxPro, and Paradox, as well as Open Database Connectivity (ODBC) client/server databases like Microsoft SQL Server. Speed up Database Access using GetRows
Once a program involving database access 'works', the next task is to get it to work really fast and efficiently. 'Getrows' is a technique that can improve the performance of your Visual Basic system. Universal Data Access Using ADO
This tutorial starts with a the historical development to help you understand why we use it. Then it discusses more recent developments in data access technologies concluding with some code examples to nail down the concepts. VB.NET - Controlling External Programs
In VB 6, you can launch an external program using the Shell function. VB.NET has a better way and this article tells you all about it.
| 