2.7.2.Create the School database and schema

  1. Download the Schools Database VAD (schools_db_dav.vad) package.

  2. Navigate to the

    System Admin -> Packages

    tab of the Virtuoso Conductor.

    Figure2.95.Conductor Packages

    Conductor Packages

  3. Scroll down to the

    Install Package

    section of the tab, use the

    Upload Package

    option

    Browse

    button to locate the schools_db_dav.vad package and click

    proceed

    .

    Figure2.96.Install package

    Install package

  4. Click the

    Proceed

    button to begin the installation process.

    Figure2.97.Install package.

    Install package.

  5. Once complete return to the

    Packages

    tab and scroll down to confirm the *schools_db* package is listed as installed.

    Figure2.98.Install package

    Install package

Create the Course Manager application using Visual Studio

  1. Launch the Visual Studio 2008 SP1 IDE.

    Figure2.99.Visual Studio 2008 SP1 IDE

    Visual Studio 2008 SP1 IDE

  2. On the

    File menu

    click

    New Project

    .

  3. Choose either

    Visual Basic

    or

    Visual C#

    in the

    Project Types

    pane.

  4. Select

    Windows Forms Application

    in the

    Templates

    pane.

  5. Enter

    CourseManager

    for the project name, and then click

    OK

    .

    Figure2.100.Create project

    Create project

Create the Course Viewer form

  1. In the CourseManager project, select the default form (Form1).

  2. In the File Properties pane, change the File Name to CourseViewer.vb or CourseViewer.cs .

  3. In Solution Explorer , double-click CourseViewer.vb or CourseViewer.cs to open the form.

    Figure2.101.CourseViewer.vb

    CourseViewer.vb

  4. In the Toolbox , expand Common Controls , drag the ComboBox control to the form, and change the name of the control to departmentList .

  5. In the Toolbox , drag the Button control to the form, change the Name of the control to closeForm , and change the Text value to Close .

  6. In the Toolbox , expand Data , drag the DataGridView control to the form, and change the Name of the control to courseGridView .

    Figure2.102.DataGridView

    DataGridView

  7. Double-click the closeForm button control. This opens the code page for the form and creates the closeForm_Click event handler method.

  8. In the closeForm_Click event handler method, type the following code that closes the form:

    Visual Basic
    
    ' Close the form.
    Me.Close()
    
    C#
    
    // Close the form.
    this.Close();