To Examples
Groceries2 Example, source code file groceries2.aspx
<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <!-- Groceries2 Example Display items from the groceries.accdb database directly in a Literal control. --> <script runat="server"> public void Page_Load(object sender, EventArgs e) { // Create and configure connection string. OleDbConnection c = new OleDbConnection( ); c.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=e:/ectserver/sjost/Database/groceries.accdb;"; // Create Command object with query from drop down list. OleDbCommand sc = new OleDbCommand("SELECT * FROM Groceries;", c); // Create DataAdapter object. OleDbDataAdapter da = new OleDbDataAdapter(sc); // Create and populate DataSet object. DataSet ds = new DataSet( ); int n = da.Fill(ds, "Groceries"); // Display data in Literal control. foreach(DataRow r in ds.Tables["Groceries"].Rows) { foreach(object cell in r.ItemArray) { litGroceries.Text += cell.ToString() + ","; } litGroceries.Text += "<br />"; } } </script> <html> <head> <title>grocery-display3.aspx Example</title> <link rel="stylesheet" class="text/css" href="../examples.css" /> <style type="text/css"> td { padding-left:0.15cm; padding-right:0.15cm; padding-top:0.15cm; padding-bottom:0.15cm; } </style> </head> <body> <h2>Groceries2 Example</h2> <p>Display from the groceries.mdb database directly from the dataset.</p> <form id="frmSelect" runat="server"> <asp:Literal ID="litGroceries" runat="server" /> </form> </body> </html>