Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Visual Basic Database Related Databases Tutorial

In this section I'll talk about how to use the database features of VB, but I'll also talk about when those features are overkill and when simpler methods of data storage can be substituted for the VB database methods.

Tutorial Details:

Visual Basic Database

I've read in print that over 80% of all VB programs require the storage of user/application generated data. That's a pretty big percentage but based on my own experience it's probably about right. The real question is how many of those use database formats such as Access and how many of those use less complicated formats? There are major tradeoffs involved in the selection of a data storage scheme. In this section I'll talk about how to use the database features of VB, but I'll also talk about when those features are overkill and when simpler methods of data storage can be substituted for the VB database methods.

Data Storage Let's get to the bottom line quickly on databases in VB. Microsoft has gone to great pains to add a lot of excellent methods for accessing data that is stored in not only Access databases, but other database formats as well.

For beginner's they've done an excellent job! But even as I give praise to Microsoft for it's efforts, I can (and will) give you a few reasons why not to use VB's database features. But even with its negatives, I still chose to use database capabilities in a lot of my applications!

The huge penalty you pay for implementing those features is an enormous growth in the size of the program that you must distribute. Simply by putting in a single data control on a form, your distribution file size grows by over 5MBytes.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Visual Basic Database Related Databases Tutorial

View Tutorial:
Visual Basic Database Related Databases Tutorial

Related Tutorials:

XML APIs for databases - JavaWorld January 2000
XML APIs for databases - JavaWorld January 2000
 
Build database-powered mobile applications on the Java platform
Build database-powered mobile applications on the Java platform
 
Good introduction to JDO
Good introduction to JDO
 
Excellent tutorial on Struts and Tiles
Excellent tutorial on Struts and Tiles This tutorial assumes knowledge of Java, JDBC, Servlets, J2EE (with regards to Web applications) and JSP Struts in a holistic manner, minus the beads and crystals. The Tiles framework makes creating reusable pages
 
SQL Database Access with DBTags
SQL Database Access with DBTags In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav
 
Eclipse plugin eva/3 Application Builder for visual development and database management
Eclipse plugin eva/3 Application Builder for visual development and database management.
 
eva/3 Application Builder supports eclipse 3
What is eva/3 Application Builder? eva/3 Application Builder assumes responsibility for the design of forms and reports via an integrated GUI Builder, the execution of procedures and the handling of diverse relational SQL databases through JDBC int
 
Berkeley DB, Java Edition I: The Basics
The original version of Berkeley DB is written in C. This means that, up until now, if a Java programmer wanted to use Berkeley DB, she would have to use some sort of translation layer (for example, JNI) to handle the communication between Java and Berkel
 
First Step towards JDBC
This article introduce you with JDBC and shows you how to create a database application to access the databases.
 
Accessing Databases Using Java and JDBC
This article will show how a Java Application, Applet or Servlet can access data stored in relational databases using the JDBC API.
 
Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.
 
Excellent Guide to Java / Databases, JDBC
JDBC is a Java API for executing SQL statements. Start here, Examples Central Sites Related Sites, Link Collections Tutorials, FAQs, References Company Newsgroups Mailing Lists, General Articles, Special Articles, Interoperability Books util
 
Servlet Essentials
This document explains the concepts of Java Servlets and provides a step-by-step tutorial for writing HTTP Servlets with complete source code for the example Servlets. The tutorial and the other chapters cover all facets of Servlet programming from a ...
 
Backing Up and Restoring A MySQL Database
Backing Up and Restoring A MySQL Database Backing Up and Restoring A MySQL Database This tutorial explains the how to backup and restore the MySQL Database. Databases are used to store large amount of precious data and it becomes very important to
 
Welcome to Java Developers paradise!
Welcome to Java Developers paradise! T his site contains many quality Java, JSP, RMI, MySQL downloads, tutorials, source codes and links to other java resources. We have large number of links to the tutorials on java which will help you learn java
 
BioInformatics Tools
BioInformatics Tools BioInformatics Tools The Bioinformatics tools are the software programs for the saving, retrieving and analysis of Biological data and extracting the information from them. Factors that must be taken into consideration when
 
First Step towards JDBC!
First Step towards JDBC! Welcome to our JDBC Section First Step towards JDBC This article introduce you with JDBC and shows you how to create a database application to access the databases. Accessing the Database from Servlet This article shows
 
Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page Connecting to MySQL database and retrieving and displaying data in JSP page This tutorial shows you how to connect to MySQL database and retrieve the data from the
 
Submit project to get developed
Submit project to get developed T his page contains answers to common questions handled by our support staff, along with some tips and tricks that we have found useful and presented here as questions. How do I Submit my Project ? Who can submit a
 
Building Search Engine Applications Using Servlets !
Building Search Engine Applications Using Servlets ! Building Search Engine Applications Using Servlets Please visit http://www.webappcabaret.com/javadevelopers/search to see running copy of our search engine. Introduction This tutorial takes
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.