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

Browse Topics

- Getting started
- Data Types
- Modules
- Operators in VB6
- VB6 Variable
- VB6 Procedures
- VB6 Control Structures
- Loops in VB6
- VB6 Exit Do & With End With
- Arrays in VB6
- User-Defined Data Types
- VB6 Constants
-
VB6 Built-in Functions
- Date and Time in VB6
- VB6 Controls
- TextBox Control
- ComboBox & OptionButton
- Label & Frame
- PictureBox & ImageBox
- Timer Control
- ListBox & ComboBox
- VB6 ScrollBar
- Control Arrays in VB6
- Files controls in VB6
- VB6 CheckBox
- Forms in VB6
- Menus in VB6
- MDI Form in VB6
- InputBox
- MessageBox
- Mouse events
- Mouse Move
- Error Handling
-
Error Handling (2)
-
VB6 Database

You are here: Visual Basic > VB6 (Beginners Tutorial)

Tutorial Main Page | Previous Page | Contents | Next Page

Visual Basic 6 (VB6) - Database Access Management

All business applications need to store large volumes of data organized in a format so that information can be retrieved efficiently and quickly as and when required. With the help of a DBMS (Database Management System), managing the data becomes easy. A DBMS is a system that manages the storage and retrieval of data in a database.

Further Microsoft Visual Basic provides tools for creating and accessing a variety of RDBMS (Relational Database Management System). An RDBMS stores and retrieves information according to the relationship defined. In a RDBMS, the data is the container of the tables in which all data is stored in the relationships is formed by data values.

A database is a collection of data that is related one to another to support a common application. For example Employee details - Name, Address, etc. Each of these collections of data continue a database.

database accessing methods are as follows;

  1. Jet Engine - Accessing Microsoft Access and Visual Basic databases.

  2. ODBC (Open Database Connectivity) - Allow access to the client server databases on a network.

  3. ISAM (Index Sequential Access Method) - Used to access flat databases such as dBase, FoxPro, ParaDox.

Click here for more in-depth lessons on ADO and OLEDB

If you need some databases for your website, I recommend you to take a look at SQLdumpster.com databases. They have hundreds of useful databases at very reasonable prices.

Contents

Database Structure and Terminology

ADO Data Control (ADODC)

Data Links

Assigning Tables

Bound Data Tools
Example - Accessing the Books Database

Creating a Virtual Table

Finding Specific Records
Example - Rolodex’ Searching of the Books Database

Data Manager
Example - Phone Directory - Creating the Database

Database Management
Example - Phone Directory - Managing the Database

Custom Data Aware Controls

Creating a Data Report
Exercise - Home Inventory Database


  

Tutorial Main Page | Previous Page | Contents | Next Page

   

Home | About Us | Privacy Policy | Contact Us

Copyright © Freetutes.com | All Rights Reserved