Start by binding a DataGrid control to a DataSet. Create an OleDbDataAdapter. Use the DataAdapter Configuration Wizard to configure the adapter. This builds a database connection for the adapter and defines the SQL query used to select data.

Select the new adapter. Below the Properties window, click the "Generate DataSet" link. This makes a DataSet that can hold the data selected by the adapter.

Add a DataGrid to the form. Set its DataSource property to the DataSet or to one of the tables selected by the DataSet.

When the form loads, use code similar to the following to make the adapter load data into the DataSet.

Private Sub Form1_Load(ByVal sender As System.Object, ByVal _
    e As System.EventArgs) Handles MyBase.Load
    Dim db_path As String = Application.StartupPath
    db_path = db_path.Substring(0, db_path.LastIndexOf("\"))
    db_path &= "\StudentData.mdb"
    connStudents.ConnectionString = _
        "Data Source=""" & db_path & """;" & _
        "Provider=""Microsoft.Jet.OLEDB.4.0"";" & _
        "persist security info=False"

    Dim warning_query As String = "IIF(Score<75, 'WARNING', " & _
        "'') AS Warning "
    Dim query As String = _
        "SELECT FirstName, LastName, TestNumber, Score, " & _
            _
        warning_query & _
        "FROM Students, TestScores " & _
        "WHERE Students.StudentId = TestScores.StudentId " _
            & _
        "ORDER BY FirstName, LastName, TestNumber"
    daStudents.SelectCommand = New _
        OleDb.OleDbCommand(query, connStudents)

    daStudents.Fill(dsStudents)
End Sub