Seeds2 Source Code

Seeds2 Example, source code file seeds2.aspx

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

// 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 table in Literal object.
    litTable.Text += "<table>\n";
    foreach (DataRow row in ds.Tables["Seeds"].Rows)
    {
        litTable.Text += "<tr><td><table>\n";
        litTable.Text += "<tr><td>Catalog Number: " +
                         row.ItemArray[0].ToString() +
                         "</td></tr>\n";
        litTable.Text += "<tr><td>Item Name: " +
                         row.ItemArray[1].ToString() +
                         "</td></tr>\n";
        litTable.Text += "<tr><td>Price: " +
                         row.ItemArray[3].ToString() +
                         "</td></tr>\n";
        litTable.Text += "</table></td>";
        litTable.Text += "<td><img src=\"images/" +
                         row.ItemArray[2].ToString() +
                         ".jpg\"></td></tr>\n";
    }
    litTable.Text += "</table>\n";     
}                                    
</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>Seeds2 Example</title>
<link rel="stylesheet" type="text/css" href="../examples.css" />
</head>

<body>
    <h2>Seeds2 Example</h2>