To Examples
Seeds1 Example, source code file seeds1.aspx
<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <!-- Display the contents of the seeds table using the Repeater 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/seeds.accdb;"; // Create Command object with query from drop down list. OleDbCommand sc = new OleDbCommand("SELECT * FROM Seeds", c); // Create DataAdapter object. OleDbDataAdapter da = new OleDbDataAdapter(sc); // Create and populate DataSet object. DataSet ds = new DataSet(); int n = da.Fill(ds, "Seeds"); // Display data in DataGrid object. repSeeds.DataSource = ds; repSeeds.DataBind(); } </script> <!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>Seeds1 Example</title> <link rel="stylesheet" type="text/css" href="../examples.css" /> </head> <body> <h2>Seeds1 Example</h2> <form id="form1" runat="server"> <asp:Repeater ID="repSeeds" runat="server"> <HeaderTemplate> <table> </HeaderTemplate> <ItemTemplate> <tr> <td> <table> <tr> <td>Catalog Number:</td> <td><%# Eval("CatalogNumber") %></tr> </tr> <td>Item Name:</td> <td><%# Eval("ItemName") %></td> </tr> <tr> <td>Price of Item:</td> <td>$<%# Eval("Price") %> </td> </tr> </table> </td> <td> <img alt="<%# Eval("ImagePrefix") %>.jpg" src="images/<%# Eval("ImagePrefix") %>.jpg" /> </td> </tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater> </form> </body> </html>