VBDP - Visual Basic Data Access Programming
A follow-up to the VB1 - Visual Basic Core Concepts course, this course demonstrates how to create database applications using Visual Basic. Topics include Data Access, Data Connections, Data Bound Controls, Recordsets and Resultsets, Validation, Debugging, SQL, Reporting and Deployment.
"I would definitely recommend this course to anyone using VB that wants to connect to an external database. [The instructor] was very clear and precise. She provided good examples and was well prepared.." -- James P. B. from San Diego, CA
"The class is very helpful on the connectivity...it was good to utilize all the different ways to connect. [The instructor was] very good, knowledgeable, and not hindered by a big ego that I've seen in other classroom settings.." -- Marc A. from San Diego, CA
"I learned...how to use the Data Environment and how to use transactions within VB. [The instructor's] practical experience made a real difference in answering real world situations with VB.." -- Donald Y. from San Diego, CA
"[The instructor] is a great instructor, who comes from a programming background, which is extremely important.." -- Tom A. from Warroad, MN
"[The instructor] is at the top of my all time instructor lists. Her presentation and depth of knowlege are impressive.." -- Ronald B. from San Diego, CA
Understanding Data Access
Working with Relational Databases
Comparing Data Providers and Data Consumers
Connecting to Data Providers
Working with the Data View Window
Accessing Data with a Data Environment
Adding a Data Environment to a Project
Adding a Connection
Creating a Command
Binding Controls to a Data Environment Automatically
Programming with Data Environment Objects
Working with Recordsets
Binding Controls to a Data Environment Manually
Using an OLE DB DataCombo Control
Using an OLE DB DataGrid Control
Working with ActiveX Data Objects (ADO)
Understanding the ActiveX Data Object Model
Creating a Connection Object
Creating a Command Object
Creating a Recordset Object
Binding Controls to a Recordset Object
Specifying a Recordset Cursor Type
Executing SQL Statements
Modifying Data Using ADO
Locking Records for Updating
Editing Data Using Bound Controls
Editing Data without Binding Controls
Adding New Records
Handling Data Access Errors
Managing Transactions
Using the ADO Data Control (ADODC)
Adding the ADODC to a Project
Adding the ADODC to a Form
Setting a Data Source and Record Source
Binding Controls to the ADODC
Designing Data Reports
Adding a Data Report to a Project
Connecting to a Data Source
Adding Fields to a Data Report
Displaying the Report
Accessing Data on SQL Server
Connecting to an SQL Server Database
Running Stored Procedures
Comparing Client-Side and Server-Side Cursors
Using a Disconnected Recordset
Packaging and Deploying a Data Access Application
Using a Resource File
Compiling an Application
Packaging an Application
Distributing MDAC 2.0 and DCOM