'How to display data in a grid where we use the OLEBDDataAdapter wizard 
'Also shows how to close a window

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        '---we only want to fill the data adapter once so only fill it the first time the page is called.
        Try
            If Not IsPostBack Then
                DsCustomers1.Clear()           'this will start fresh

                '---now fill the adapter and pass it the name of the DS and the Table name
                OleDbDataAdapter1.Fill(DsCustomers1, "customers")

                '---make it so! You must bind the grid here at run time
                DataGrid1.DataBind()

            End If

        Catch

            '---show the label if we bomb out
            lblError.Visible = True
            lnkEnd.Visible = True

        End Try

    End Sub

    Private Sub LinkButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lnkEnd.Click
        Response.Write("<script>window.close()</script>")
    End Sub