01.<%@ Page Language="VB" %>
02.<html>
03.<head>
04. <title>ThaiCreate.Com ASP.NET - AccessDataSource</title>
05.</head>
06.<body>
07. <form id="form1" runat="server">
08. <asp:GridView id="myGridView" runat="server" AutoGenerateColumns="False"
09. DataKeyNames="CustomerID" DataSourceid="myDSource" AllowSorting="True">
10. <Columns>
11. <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />
12. <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
13. <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
14. <asp:BoundField DataField="CountryCode" HeaderText="CountryCode" SortExpression="CountryCode" />
15. <asp:BoundField DataField="Budget" HeaderText="Budget" SortExpression="Budget" />
16. <asp:BoundField DataField="Used" HeaderText="Used" SortExpression="Used" />
17. </Columns>
18. </asp:GridView>
19. <asp:AccessDataSource id="myDSource" runat="server"
20. DataFile="~/database/mydatabase.mdb" SelectCommand="SELECT * FROM [customer]">
21. </asp:AccessDataSource>
22. </form>
23.</body>
24.</html>
