<%-- Persons Example --%>
<%@ 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 Page_Load(object source, EventArgs e)
{
OleDbConnection c = new OleDbConnection();
c.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0; +
Data Source=c:\\Database\\persons.mdb;
OleDbCommand sc = c.CreateCommand();
sc.CommandType = CommandType.Text;
sc.CommandText = SELECT * FROM Persons;;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = sc;
DataSet ds = new DataSet();
int n = da.Fill(ds, Persons);
}
</script>
<html xmlns=http://www.w3.org/1999/xhtml >
<head id=Head1 runat=server>
<title>Untitled Page</title>
</head>
<body>
<form id=form1 runat=server>
<div>
<p><asp:TextBox runat=server
ID=txtName /> Name</p>
<p><asp:TextBox runat=server
ID=txtGender /> Gender</p>
<p><asp:TextBox runat=server
ID=txtAge /> Age</p>
<p><asp:Label runat=server
ID=Label1 Text=Label1 /></p>
</div>
</form>
</body>
</html>