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>