From the basics, the tutorial brings you to a complete manipulation of the database and takes you one level ahead. This will incite you to think better and be more creative.
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.
Database controls are ideal if you want to get in, get the job done, and then get out. In this section we'll discuss the controls available to the database programmer. VB falls short, however, in helping beginners create databases from scratch.
To selectively display records in a recordset, the feature to use is SQL - Structured Query Language. By creating a query (a text string which tells VB what to include in a recordset or what actions to take against the data in a recordset) you can greatly simplify the code you have to write in an application that utilizes databases.
In the previous lesson you have learned how to create a simple database application using data control. In this lesson, you will work on the same application but use some slightly more advance commands.
Data control is not a very flexible tool as it could work only with limited kinds of data and must work strictly in the Visual Basic environment. To overcome these limitations, we can use a much more powerful data control in VB known as ADO control.
106 times | 
category: 
.NET (11)