To Examples
access-datasource.aspx Source Code
<!-- access-datasource.aspx Example Display the on sale items from the groceries.mdb database in a DataGrid control. Use an AccessDatasource object to obtain the data. --> <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <html> <head> <title>grocery-display3.aspx Example</title> <link rel=stylesheet class=text/css href=examples.css /> <style class=text/css> td { padding-left:0.15cm; padding-right:0.15cm; padding-top:0.15cm; padding-bottom:0.15cm; } </style> </head> <body> <h2>grocery-display3.aspx Example</h2> <p>Display the on sale items from the groceries.mdb database in a DataGrid control.<br /> Pick a select statement for choosing which data to display.</p> <form id=frmSelect runat=server> <asp:AccessDataSource ID=adsGroceries runat=server DataFile=e:/ectserver/sjost/Database/groceries.mdb SelectCommand=SELECT Item, Code, Quantity, Price, OnSale FROM Groceries;> </asp:AccessDataSource> <p> <asp:DataGrid ID=dgGroceries runat=server AutoGenerateColumns=True style=font-size:90% DataSourceID=adsGroceries /> </asp:DataGrid> </p> </form> </body> </html>