MDBをデータソースとしてDataGridを表示させる

Accessデータベースを読んでデータグリッドとして表示させてみる
のそーす。

コード部分

Sub Page_Load(Sender As Object, E As EventArgs)

    DataGrid1.DataSource = MyQueryMethod
    DataGrid1.DataBind()

End Sub

Function MyQueryMethod() As System.Data.IDataReader
    Dim connectionString As String = _
        "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4;" +_
        "Data Source=C:\temp\authors.mdb"
    Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)

    Dim queryString As String = "SELECT [Authors].* FROM [Authors]"
    Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
    dbCommand.CommandText = queryString
    dbCommand.Connection = dbConnection

    dbConnection.Open
    Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

    Return dataReader
End Function

HTML部分

    <form runat="server">
        <asp:datagrid id="DataGrid1" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" EnableViewState="False">
            <HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle>
            <ItemStyle backcolor="#DEDFDE"></ItemStyle>
        </asp:datagrid>
    </form>