<%@ 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=c:/Database/umbrellas.mdb;
c.Open();
// Declare variables.
string cred;
int quantity;
double totalorder;
// Get credit card number.
cred = txtCreditCard.Text;
// Compute total order.
quantity = int.Parse(ddlQuantity.SelectedValue);
totalorder = quantity * 9.50;
// Get current date.
string date = DateTime.Now.ToString();
// Write order to database.
string sql = INSERT INTO UmbrellaOrders VALUES ( +
' + cred + ', +
' + date + ', +
totalorder + );;
OleDbCommand command = new OleDbCommand(sql, c);
command.ExecuteNonQuery();
// Close connection.
c.Close();
// Display acknowledgement.
litOutput.Text =
Your order has been placed.<br />;
}
</script>
<!DOCclass 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>Untitled Page</title>
</head>
<body>
<form id=form1 runat=server>
<div>
<h2>Order Your Umbrella</h2>
<p>How many umbrellas do you want to order?</p>
<p>Quantity:<br />
<asp:DropDownList ID=ddlQuantity runat=server>
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem>5</asp:ListItem>
<asp:ListItem>6</asp:ListItem>
<asp:ListItem>7</asp:ListItem>
<asp:ListItem>8</asp:ListItem>
<asp:ListItem>9</asp:ListItem>
<asp:ListItem>10</asp:ListItem>
</asp:DropDownList></p>
<p>Credit Card Number:<br />
<asp:TextBox ID=txtCreditCard runat=server /></p>
<p><asp:Button ID=btnSubmitOrder runat=server
Text=Submit Order
OnClick=btnSubmitOrder_Click /></p>
<p><asp:Literal ID=litOutput runat=server
/></p>
</div>
</form>
</body>
</html>