Chapter 20. Database Basics

function OpenWin(url, w, h) { if(!w) w = 400; if(!h) h = 300; window.open(url, "_new", "width=" + w + ",height=" + h + ",menubar=no,toobar=no,scrollbars=yes", true); } function Print() { window.focus(); if(window.print) { window.print(); window.setTimeout('window.close();',5000); } }
Team-Fly    

Special Edition Using Microsoft® Visual Basic® .NET
By Brian Siler, Jeff Spotts
Table of Contents
Part V:  Visual Basic and Databases


In this chapter

Understanding Databases

Designing a Database

Introducing the Structured Query Language

Using the SELECT Statement

Using SQL Action Statements

Using DDL Statements

Storing SQL Statements in the Database

Troubleshooting Hints

Most business-oriented applications work with data in one form or another. We're not talking about computer data like a loop counter variable, but actual business information, such as the number of units sold or customer name. For business data stored on a computer to be useful, you need a system that allows you to efficiently analyze and maintain it. A database management system (or database for short) is one way to store such data.

This is the first of four chapters in this book related to databases. As you will learn, Visual Basic .NET can create powerful data management programs with a little planning and effort. The most fundamental part of that planning is in how the database is structured. A poorly designed database can doom even the most well-intentioned program from the start. On the other hand, a well-designed database can make a programmer's life much easier.

Another key issue with managing data is using the database to answer queries. In the second half of this chapter, we will introduce the Structured Query Language (SQL). By learning a few SQL commands, you can retrieve information from a database and issue commands to manipulate the data contained within it.


    Team-Fly    
    Top
     



    Special Edition Using Visual Basic. NET
    Special Edition Using Visual Basic.NET
    ISBN: 078972572X
    EAN: 2147483647
    Year: 2001
    Pages: 198

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net