Hot-Link Menu in Right-Side Column

Wal Mart Online → Store Pickup → Free Shipping
WM468X60_ko_static.gif


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


Choose:

  • 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


Home


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

If/Then/Else

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

Enumerations

Nullable Types


Loop Constructs

For Next Loop

Do While Loop


Do Until Loop

Do...Loop-While

Do...Loop-Until


Exit Do | Exit For

Do...Loop


Nested Loops


Arrays

Array Declaration


Rnd( ) Function

Listbox Control


KeyPressEventArgs


Parallel Arrays

Key Event Args


Dynamic Arrays

Redimension Array

Set Breakpoint

Start Debugger


ReDim Preserve


MultiDimensional Arrays

DataGridView Control


Length and Sort Methods


Structures

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