Tom's Subject Directory & City Building Fan Site

The first label is for displaying the status of the server connection. Its properties are set as (default if not listed);

1. Name = svrStatus
2. AutoSize = True
3. TabIndex =  4
4. Text = Server Status

Second label;

1. TabIndex =  5
2. Text = Username

Third Label;

1. TabIndex =  6
2. Text =  Password

First (upper) TextBox, for User Name input;

1. Name = TxtUsername*
2. TabIndex =  0

Second TextBox, for Password input;

1. Name = txtPassword
2. TabIndex =  1

Login Button;

1. Name = btnLogin
2. TabIndex =  2
3. Text = Login

Refresh Button;

1. Name = btnRefresh
2. TabIndex =  3
3. Text = Refresh

The Login button submits the Username and Password as part of the SELECT query to the MySql database. The Refresh button clears the textboxes, gives focus to the Username TextBox and calls Connect() to show a status change. This button and code can be eliminated completely without affecting the purpose of this article.

*    Used to build query string and taken from DB table shown in Part III

**    Allows testing different usernames and passwords without restarting debug.