Visual Basic® .NET Database Programming

Table of contents

1. Copyright
2. About the Author
3. Tell Us What You Think!
4. Introduction
5. Data Storage Alternatives
   1. Compiled In Data
   2. Registry
   3. Relational Databases
   4. Specific Relational Database Engines
   5. More Exotic Databases
   6. Summary
6. Database Design
   1. Application Design Approaches
   2. Requirements
   3. Entities
   4. Refining the Design
   5. Master-Detail Relationships
   6. Normalization
   7. Keys
   8. Indexes
   9. Constraints
   10. Design Tools
   11. Designing Databases With Microsoft Access
   12. Building a Database with SQL
   13. Summary
7. Security
   1. Degrees of Security
   2. Controlling Privileges
   3. Controlling Access with Views
   4. SQL Server Security Procedures
   5. Summary
8. Off to See the Wizard
   1. Data Link Properties
   2. The Data Form Wizard
   3. Query Builder
   4. Data Adapter Configuration Wizard
   5. Using The Data Adapter
   6. Summary
9. The DataSet Family of Objects
   1. DataSet
   2. DataTable
   3. DataRow
   4. DataColumn
   5. DataRelation
   6. DataView
   7. DataRowView
   8. Summary
10. Database Connections
    1. Data Connection Methods
    2. Program-Generated Data
    3. XML Data
    4. SQL Server
    5. OLE DB
    6. Example Program RunScript
    7. Summary
11. XML Databases
    1. What Is XML?
    2. Editing XML Files
    3. Schemas
    4. Loading XML Data in Visual Basic
    5. Saving XML Data From Visual Basic
    6. Overwriting Files
    7. Summary
12. Bound Controls
    1. Basic Binding
    2. Record Selection with Bound Controls
    3. Selecting a Calculated Field
    4. A TreeView Display
    5. DataViews
    6. Binding Controls with Code
    7. DataGrid
    8. Summary
13. Data Safety
    1. EasyDraw
    2. Storing Data
    3. Drawing Existing Objects
    4. Drawing New Objects
    5. DataSafe
    6. Menu Commands
    7. MRU List
    8. Data Validation
    9. Summary
14. A Single-User Example
    1. A One-Form Design
    2. A Tabbed Design
    3. Summary
15. Multi-User Programming
    1. Program OrderEntryMultiUser
    2. Database Redesign
    3. Reservations
    4. Source Code
    5. Modifications
    6. Summary
16. Query By Example
    1. Features
    2. Programming the RecordList Form
    3. RecordList Form Internals
    4. Sorting Records
    5. Summary
17. Discovering Database Structure
    1. Learning About Servers
    2. Learning About Databases
    3. Learning About Tables
    4. Learning About Relationships
    5. Learning About Fields
    6. Meta-Learning
    7. Program ExploreServer
    8. Program ExploreRelations
    9. Summary
18. SQL
    1. CREATE DATABASE
    2. DROP DATABASE
    3. ALTER DATABASE
    4. CREATE TABLE
    5. ALTER TABLE
    6. DROP TABLE
    7. CREATE INDEX
    8. DROP INDEX
    9. CREATE VIEW
    10. DROP VIEW
    11. SELECT
    12. INSERT
    13. UPDATE
    14. DELETE
    15. Aggregate Functions
    16. Joins
    17. Summary
19. The Visual Basic .NET Development Environment
    1. Getting Started
    2. Creating a New Solution
    3. Toolbars
    4. Toolbox Tabs
    5. Properties
    6. Finding Lost Windows
    7. Summary
20. Index