Hot-Link Menu in Right-Side Column

Wal Mart Online → Store Pickup → Free Shipping

Microsoft Access Database Configuration

Pressing the Next button on the Database Configuration Dialog Box brings up the Configure Select Statement Dialog Box as illustrated in the diagram below:

Access Database Configure Select Statement

Figure CC-7: Configure Microsoft Access Select Statement

Buy from Centurion

Configure the Select statement to retrieve data from the Products category as indicated in the diagram above. Also check the following columns:

  • ProductID
  • Name
  • ShortDescription
  • LongDescription
  • ImageFile
  • UnitPrice

After making all of the proper selections, press the Next button on the dialog box. This will bring up the Test Query dialog box as illustrated in the diagram below:

Microsoft Access Test Query

Figure CC-8: Microsoft Access Database Test Query Dialog Box

Help Support Mr. Centurion - Donate or Visit any Sponsor

No Purchase Necessary.

Help us keep this site operational by making a donation. Any amount is greatly appreciated. OR, if you visit our sponsor, they will make a donation for you, just for visiting.

Thank you

It is a good idea to press the Test Query button, to make sure all of the entries are correct, unless you really know what you're doing, in which case you probably wouldn't be here, reading this tutorial. When you press the Test Query button, the textbox control should fill with Part Numbers, Names, Description, etc. If it does not, some previous step has a small error, and you will need to go back and correct it. Otherwise, you're probably good, and you can press the Finish button, and celebrate your success by clicking on a few Google Ads, and get some free software or something.

Once we've all finished celebrating, we need to come back to reality, and realize, that there is still more work to do, and we shouldn't be wasting all of our time clicking those Google Ads, no matter how much fun we may think it is. To the right of the Drop Down List is a little arrow, which displays the Smart Tag, but it is a little hard to see. Other than that, if you right-click on the drop-down list, the Properties Dialog Box is displayed, in the manner we are used to and come have to know and love. Doing so brings up the properties Dialog Box, with the Smart Tag option. Select the Smart Tag option as indicated in the illustration below:

VB.NET Drop Down List Smart Tag

Figure CC-9: Drop Down List Smart Tag

Excellent Tech Support - Centurion Approved

Selecting the Smart Tag option brings up the following dialog box:

Choose Data Source for Drop Down List

Figure CC-10: Choose Data Source for Drop Down List

Visit Our Sponsor to Help Support Our Site - No Purchase Necessary

Selecting the Choose Data Source option brings up the Choose Data Source Dialog Box as illustrated in the diagram below:

Choose Drop Down List Microsoft Access Data Source

Figure CC-10: Choose Drop Down List Access Data Source Dialog Box


  • AccessDataSource1 → ddlProducts.DataSource

  • Name → ddlProducts.FieldToDisplay

  • ProductID → ddlProducts.DataFieldValue

for the available option selections in the Data Source Dialog above. Choose Centurion Online for Top Quality products from brand name manufacturers at competitive pricing

In order to continue with this guide, and continue the discussion on Binding a control to Microsoft Access Database: Press the Button below:

Visit Our Sponsor to Help Support Our Site - No Purchase Necessary


Visual Basic

Introduction to VB.NET

.NET Framework

VS2008 IDE

How VB is Compiled

Start Visual Studio

Windows Form App

Save Your Work

VB OOP Programming

Visual Basic Code

Exit Code

Button Event Code

Coding Recommendations


Error List Window

Comment Syntax

Help Window

Language Essentianl

Built-In Data Types

Declare Variables

Declare Constants

Code Arithmetic Expressions

Assignment Statements

Operator Precedence

Type Casting

Math Class

String Declaration

Conversion Functions

Conversion Methods

Formatting Functions

String Formatting

Variable Scope


Nullable Types

Loop Constructs

For Next Loop

Do While Loop

Do Until Loop



Exit Do | Exit For


Nested Loops


Array Declaration

Rnd( ) Function

Listbox Control


Parallel Arrays

Key Event Args

Dynamic Arrays

Redimension Array

Set Breakpoint

Start Debugger

ReDim Preserve

MultiDimensional Arrays

DataGridView Control

Length and Sort Methods


Pad Right

Split Method

IsNumeric Function

Multiform Projects

Add Form To Project

Form Object Methods

Form Show Method

ShowDialog Method

Form Close Method

Form Accept Button

Multiform Project Example

ASP.NET Web Programming

Create Data Source

Configure Access Data Source

Add Product Class

Extract Local Database Data

Order PageLoad VB Code

Add New Web Page

Set Start Page

Display Cart Aspx Code

Display Cart Design View

Sorted List Definition

VB.NET Session State

Create CartItem Class

GetCartContents Function

Add To Cart Event Handler

Remove Cart Item Event

Clear Cart Event Handler

Can't open VisitorHistory.txt for reading