<%@ 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\\team-mascots.mdb;
string sql = SELECT * FROM Mascots;
OleDbCommand command = c.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = command;
DataSet ds = new DataSet();
int n = da.Fill(ds, Mascots);
}
</script>
<html xmlns=http://www.w3.org/1999/xhtml>
<head runat=server>
<title>ProbA4</title>
</head>
<body>
<h2>ProbA4: Mascots</h2>
<form id=form1 runat=server>
<p><asp:TextBox runat=server ID=txtTeam /></p>
<p><asp:Button runat=server ID=btnSubmit
Text=Get Mascot OnClick=btnSubmit_Click /></p>
<p><asp:Literal runat=server ID=litMascot /></p>
</form>
</body>
</html>