<%@ Page Language=C# %>
<%@ Import Namespace=System.Data %>
<%@ Import Namespace=System.Data.OleDb %>
<!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd>
<script runat=server>
public void btnSubmit_Click(object sender, EventArgs e)
{
OleDbConnection c = new OleDbConnection();
c.ConnectionString =
Provider=Microsoft.Jet.OLEDB.4.0; +
Data Source=c:\\Database\\seed-orders.mdb;
c.Open();
string sql = INSERT INTO Orders VALUES ('Peas', 5, 3.45);;
OleDbCommand command = new OleDbCommand(sql, c);
command.ExecuteNonQuery();
c.Close();
}
</script>
<html xmlns=http://www.w3.org/1999/xhtml >
<head runat=server>
<title>Problem A3</title>
</head>
<body>
<h2> Problem A3: record-order.aspx</h2>
<form id=form1 runat=server>
<p><asp:Button runat=server Text=Submit Order
OnClick=btnSubmit_Click /></p>
<p><asp:Literal runat=server /></p>
</form>
</body>
</html>