Linux (in uni)

Type the following commands in tcsh
1.  xhost +
2.  usr/vmware/vmware

Windows

1.  Download spd361.mdb from prac site

2.  Start Visual Studio .NET

3.  File --> New Project --> VB C#/J# or just VB

4.  On left hand side menu, click on server explorer
    It will display a list

5.  Data connections --> Add new connection
    It will display a new window

6.  Provider --> Microsoft jet 4.0 OLE DB provider - next
-   Select db = spd361.mdb
-   Clear the username and test connections

-   Open server explorer
    -   Data Connections
        -   Access spd361
            -   Tables
                -   Random data

-   Drop random data into form

-   check for ole adaptor
-   Check for ole db Connection

-   DB - Connection <-> Adpator <-> Dataset (snapshot)

-   right click on adaptor  - gen dataset
                            - ok
                            - view XML source (bottom)

-   drag up 2 textbooks and a button onto windows form

Form Code in Visual Basic

Public Class Form1
    Inherits System.Windows.Forms.Form

+windows generated code

Private Sub Button1_Click(ByVal sender As System.Object, 
    ByVal e As System.EventArgs) Handles Button1.Click
        // ADD THE FOLLOWING LINES
        Dim x As Integer
        x = Int32.Parse(TextBox1.Text)
        TextBox2.Text = DataSet11.randomData(x).value
        // END
    End Sub

Private Sub Form1_Load(ByVal sender As System.Object, 
    ByVal e As System.EventArgs) Handles MyBase.Load
        // ADD THIS LINE
        OleDbDataAdapter1.Fill(DataSet11)
    End Sub
End Class