Computer Programming School - Web School
Da Clock and Date Stuff
Page last modified: 02 July 2008

Source Code For Getting Data From Microsoft Access Via Dot Net

This Page Uses A Data Grid Control -- Literally a "Drag and Drop" onto The Page To Display The Database Content

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="tryAccess.aspx.vb" Inherits="tryAccess" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>First Attempt At ASPX Connect to Access Database</title>
</head>
<body>
    <h2>Outputting A Table From Microsoft Access in ASPX (DOT Net)</h2>
    <h4>These are the courses in the table:</h4>
    <form id="form1" runat="server">
    <div>
    
    </div>
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1" 
        EmptyDataText="There are no data records to display.">
        <Columns>
            <asp:BoundField DataField="courseID" HeaderText="courseID" 
                SortExpression="courseID" />
            <asp:BoundField DataField="courseName" HeaderText="courseName" 
                SortExpression="courseName" />
            <asp:BoundField DataField="courseProgram" HeaderText="courseProgram" 
                SortExpression="courseProgram" />
            <asp:BoundField DataField="courseLength" HeaderText="courseLength" 
                SortExpression="courseLength" />
            <asp:BoundField DataField="coursePrice" HeaderText="coursePrice" 
                SortExpression="coursePrice" />
            <asp:BoundField DataField="courseOption" HeaderText="courseOption" 
                SortExpression="courseOption" />
        </Columns>
        <SelectedRowStyle BackColor="#99CCFF" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString1.ProviderName %>" 
        SelectCommand="SELECT [courseID], [courseName], [courseProgram], [courseLength], [coursePrice], [courseOption] FROM [courses]">
    </asp:SqlDataSource>
    </form>
    
</body>
</html>