VB2019 VB2017 VB2015 VB2013 VB2012 VB2010 VB2008 VB6 VB Sample Code 中文VB About Us

Lesson 27 SQL Queries

To search for an information in a database, we must use SQL query. SQL stands for Structures Query Language. Using SQL keywords, we are able to select specific information to be displayed based on certain criteria.

The most basic SQL keyword is SELECT, it is used together with the keyword FROM to select information from one or more tables from a database. The syntax is:

SELECT fieldname1,fieldname2,.....,fieldnameN  FROM  TableName

fieldname1, fieldname2,......fieldnameN are headings of the columns from a table of a database. You can select any number of fieldname in the query. If you wish to select all the information, you can use the following syntax:

SELECT  * FROM  TableNam

To learn the details of using SQL, we suggest you obtain a copy of Visual Basic 6 Made Easy.


Price: $20.00


VISUAL BASIC 6 MADE EASY is an eBook written by our webmaster, Dr.Liew.  It was used as a textbook by the University of Wesleyan. You can use this book as a textbook for your VB course or project.

Preview the book

By reading this book, you can:

  • Understand the basic concepts of Visual Basic 6 programming
  • Create your own VB6 programs right from the beginning
  • Get programming ideas from many interesting sample programs. The sample programs include star war, snakes and ladders game, reversi, home loan calculator, BMI calculator, library system, calculator and more.
  • Modify the codes easily to suit your needs.

You can also use the book in many ways, such as:

Order this book and you can Download the FREE Source Codes for the sample VB6 programs illustrated in this book. Click the Order button below to get your e-book and the free stuff.

You need PayPal account to order our E-book. If you don't have PayPal Account, get your PayPal account by clicking the banner below:

Sign up for PayPal and start accepting credit card payments instantly.

*Please wait for 10 seconds for PayPal to redirect you to E-book Download Page after ordering and making payment.

Mode of Delivery: Download

Warmest Regards



This site and the products and services offered on this site are not associated, affiliated, endorsed, or sponsored by Microsoft, nor have they been reviewed tested or certified by Microsoft.

Contact Information

If you require assistant and technical support, please contact:Admin

Copyright©2008 Dr.Liew Voon Kiong. All rights reserved |Contact|Privacy Policy