To connect the MySQL database with Visual Basic, MySQL ODBC drivers should be installed and configured on the system. The following steps show how was the installation process have been done. Download MySQL for Windows (x86) setup file from their official web site. (http://dev.mysql.com/downloads/mysql/5.0.html) Downloaded ODBC 3.5.1 MSI Installer (stable) for Windows (x86) from http://dev.mysql.com/downloads/connector/odbc/3.51.html Once downloaded the files and before installing them t... more »

Variables I have enabled the Option Explicit statement, because to declare all the variables in my program. [I checked the Require Declaration option on the Editor Tab of the Option dialog box] To declare a variable I used the following statements: •    Dim (e.g. Dim filenumber As Integer) •    Private •    Public •    Static The following table lists the scope of a variable and its accessibility from various sections of a project.... more »

Programming techniques The implementation phase of software development is also concerned with translating the design specification into source code. This section describes the overall process of implementing the Webmaster Console (WmConsole). The technical configuration about the connection between the MySQL database and Visual Basic is described. And descriptions of the screen shots and source code of the WmConsole is also explained. Coding style It has been recognised that a good ... more »