Tutorial 4 -: DataBase Programming

In this tutorial, Database programming using VB  and OleDb is explained using Student Database example. The program uses MS Access as the back end. A basic understanding of Structured Query Language (SQL) is assumed.

Most applications require some form of data access. If you are creating a new application, you have two excellent data access choices: ADO and OLE DB.

ADO

For applications written in native code, ADO provides a COM-based application level interface for OLE DB data providers.

OLE DB

OLE DB is the strategic system-level programming interface for accessing data and is the underlying technology for ADO as well as a source of data for ADO . OLE DB is an open standard for accessing all kinds of data both relational and non-relational data OLE DB provides consistent, high-performance access to data and supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects using live connections to data in relational databases and other stores.

Choosing OLE DB

The choice to write to OLE DB directly must be evaluated against using an easier data access method such as ADO. The factors affecting your decision to use OLE DB's COM-level data access include:

Performance

ADO is very fast, but they do insert an extra layer of abstraction between your application and the data provider when working with OLE DB data sources.

Functionality

OLE DB defines native interfaces designed to be extensive and extensible enough to expose all of a database's underlying behavior, semantics and functionality.

Maintenance

Using the OLE DB data access technology affects the cost of long-term maintenance for your application.

Watch the Youtube Video For VB Student Database Example

Part2



Download the source of VB Student Database Programming Example

   

 
Download VB In Easy Steps
Main Features
» Easy to learn VB.

» Tutorials with source & video.

» Can master within 9 hours.

» All VB concepts in detail.

» Become confident in VB applications.

» Cost effective.
   
Subscribe Newsletter
Register to the site for free, and subscribe to the newsletter. You will receive new articles and special content not available elsewhere on the site, right into your e-mail box!