Login Register
Home | Snippets | ASP | Define and use asp:AccessDataSource

New Code Snippets

Popular Code Snippets

Today's Code Snippets Searches

Currently Searching

Define and use asp:AccessDataSource

Submitted by:Pitter Alderson

Date added:06 February, 2012

Category:ASP

An example code how to define and use asp:AccessDataSource

Tags: access data source

Code Snippet: 

<html>
<head>
   <title>DataList From Access</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:DataList ID="DataList1" runat="server" DataSourceID="AccessDataSource1" DataKeyField="CategoryID"
            RepeatColumns="3" RepeatDirection="Horizontal">
            <ItemTemplate>
                <table>
                    <tr>
                        <td style="width: 100px">
                            <asp:Label ID="Label1" runat="server" Text='<%# Eval("CategoryID") %>'></asp:Label>
                        </td>
                    </tr>
                    <tr>
                        <td style="width: 100px">
                            <asp:Label ID="Label2" runat="server" Text='<%# Eval("Description") %>'></asp:Label>
                        </td>
                        <td style="width: 100px">
                            <asp:Label ID="Label3" runat="server" Text='<%# Eval("CategoryName") %>'></asp:Label>
                        </td>
                    </tr>
                </table>
                <br />
                <br />
            </ItemTemplate>
        </asp:DataList>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
            DataFile="Northwind.mdb"
            SelectCommand="SELECT * FROM [Categories]"></asp:AccessDataSource>
    </form>
</body>
</html>
 
 

Comments