Freetutes.com

VB6 beginners tutorial - Learn VB6

Advanced VB6 tutorial - Learn Advanced VB6

VB .NET - Learn Visual Basic .NET

Systems Analysis - System analysis and Design tutorial for Software Engineering


You are here: Visual Basic > Advanced VB6 tutorial > Chapter 9

Chapter 9 - Creating Data Services (Database Management): Part II

( Contents )

This is the second chapter that discusses data access. The preceding chapter Chapter 8, "Creating Data Services: Part I" introduced ADO concepts and discussed general ADO programming techniques.

This chapter focuses on some of the more specialized concerns with ADO programming, including various data-access models, the use of SQL and stored procedures, record locking, and database transactions.

Contents

  1. ADO Data-Access Models
    Accessing Data With the Execute Direct Model
    Accessing Data With the Prepare/Execute Model
    Accessing Data With the Stored Procedures Model
    How to Choose a Data-Access Model

  2. Using Stored Procedures
    Creating Stored Procedures
    Using the Parameters Collection to Manipulate and Evaluate Parameters for Stored Procedures
    Using Stored Procedures to Execute Statements on a Database
    Using Stored Procedures to Execute Processes Without Cursors
    Using Stored Procedures to Return Records to an Application

  3. Using Cursors
    Using Cursor Locations
    Using Cursor Types

  4. Managing Database Transactions

  5. Writing SQL Statements
    Writing SQL Statements that Retrieve and Modify Data
          Using the Where Clause to Filter Rows
          Using the Order By Clause to Logically Sort Rows
    Writing SQL Statements that Use Joins to Combine Data from Multiple Tables
          Using the Where Clause to Connect Tables
          Using JOIN Clauses to Connect Tables

  6. Using Locking Strategies to Ensure Data Integrity

  7. Choosing Cursor Options


  

Get Started >>

Home | Link to Us | About Us | Privacy Policy | Contact Us

Copyright © Freetutes.com | All Rights Reserved