You are previewing Visual Basic® .NET Database Programming.
O'Reilly logo
Visual Basic® .NET Database Programming

Book Description

Visual Basic.NET Database Programming walks the readers step-by-step through the topics they need to know to use databases effectively. This book teaches with real-world scenarios how to load, display, manipulate, modify and save data in databases. It shows the reader how to build multi-tier applications that implement enterprise-wide business solutions, build Web Servers, manage large amounts of data, find specific records, sort data, perform complex queries, and use XML--an integral part of data handling in Visual Basic.NET.

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