To Examples
seeds2.aspx Source Code
<!-- seeds2.aspx Example Display a seed catalog with images. The seed order can be registered in the transactions database. --> <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat=server> public void btnSubmitOrder_Click(object sender, EventArgs e) { // Create and configure connection string. OleDbConnection c = new OleDbConnection( ); c.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0; + @Data Source=e:\ectserver\sjost\Database\seed-orders.mdb; c.Open( ); // Declare variables. string txtCustID; int cucQuant, letQuant, grpQuant, swcQuant, wtmQuant; double cucEP, letEP, grpEP, swcEP, wtmEP, total; // Obtain customer id. string custId = txtCustId.Text; // Obtain values from textboxes. cucQuant = int.Parse(txtCucQ.Text); letQuant = int.Parse(txtLetQ.Text); grpQuant = int.Parse(txtGrpQ.Text); swcQuant = int.Parse(txtSwcQ.Text); wtmQuant = int.Parse(txtWtmQ.Text); // Compute extended prices. cucEP = 2.56 * cucQuant; letEP = 1.98 * letQuant; grpEP = 3.17 * grpQuant; swcEP = 2.36 * swcQuant; wtmEP = 2.99 * wtmQuant; // Compute total order. total = cucEP + letEP + grpEP + swcEP + wtmEP; // Obtain current date: string date = DateTime.Now.ToString( ); // Write order to database. string sql = INSERT INTO Orders VALUES ( + ' + custId + ', + ' + date + ', + total + , + cucEP + , + letEP + , + grpEP + , + swcEP + , + wtmEP + );; OleDbCommand command = new OleDbCommand(sql, c); command.ExecuteNonQuery(); // Close connection. c.Close(); // Display acknowledgement. litMessage.Text = Thankyou<br /> + Your order has been processed.<br /> + It will be shipped in 3 to 5 business days,<br /> + sql; } </script> <html> <head> <title>seeds2.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; } img { width:100px; height:100px; } .tbq { width:50px; } .tbep { width:100px; } .c { text-align:right; } .vc { vertical-align:center; } </style> </head> <body> <h2>seeds2.aspx Example</h2> <h3>Display a seed catalog with images.<br /> The seed order can be registered in the transactions database.</h3> <p>The text, images, and controls are not obtained from a database.</p> <form id=frmSeeds runat=server> <p>Customer ID <asp:TextBox id=txtCustId Width=120px runat=server /><br /></p> <p> <asp:Button id=btnSubmitOrder Text=Submit Order runat=server Width=230px OnClick=btnSubmitOrder_Click /> </p> <p style=color:#009000;> <asp:Literal id=litMessage Text= runat=server /> </p> <table> <tr class=vc> <td class=r>Cucumber</td> <td><img src=images/cuc.jpg></td> <td><table> <tr><td>Unit Price</td><td>Quantity</td></tr> <tr> <td>$2.56</td> <td><asp:TextBox id=txtCucQ runat=server Text=0 CssClass=tbq /></td> </tr> </table> </td> </tr> <tr class=vc> <td class=r>Lettuce</td> <td><img src=images/let.jpg></td> <td><table> <tr><td>Unit Price</td><td>Quantity</td></tr> <tr> <td>$1.98</td> <td><asp:TextBox id=txtLetQ runat=server Text=0 CssClass=tbq /></td> </tr> </table> </td> </tr> <tr class=vc> <td class=r>Green Pepper</td> <td><img src=images/grp.jpg></td> <td><table> <tr><td>Unit Price</td><td>Quantity</td></tr> <tr> <td>$3.17</td> <td><asp:TextBox id=txtGrpQ runat=server Text=0 CssClass=tbq /></td> </tr> </table> </td> </tr> <tr class=vc> <td class=r>Sweet Corn</td> <td><img src=images/swc.jpg></td> <td><table> <tr><td>Unit Price</td><td>Quantity</td></tr> <tr> <td>$2.36</td> <td><asp:TextBox id=txtSwcQ runat=server Text=0 CssClass=tbq /></td> </tr> </table> </td> </tr> <tr class=vc> <td class=r>Watermelon</td> <td><img src=images/wtm.jpg></td> <td><table> <tr><td>Unit Price</td><td>Quantity</td></tr> <tr> <td>$2.99</td> <td><asp:TextBox id=txtWtmQ runat=server Text=0 CssClass=tbq /></td> </tr> </table> </td> </tr> </table> </form> </body> </html>