asp.net.ph Source Code Viewer

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<html>
<title>Retrieving OLEDB Data Into a DataSet</title>
<link rel="stylesheet" href="/shared/netdemos.css">

<script language="C#" runat="server" src="displayData.cs" />

<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e ) {
   // set up the connection
   OleDbConnection myConn = new OleDbConnection ( 
      "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=|DataDirectory|dbtutor.mdb" );

   // set up the query
   string query = "SELECT ProductCode, ProductType, ProductName, ProductDescription FROM Products";

   // initialize dataadapter
   OleDbDataAdapter myCmd = new OleDbDataAdapter ( query, myConn );

   // initialize dataset object
   DataSet myData = new DataSet ( );

   // fill dataset with query results
   myCmd.Fill ( myData, "Products" );

   // call method to display dataset contents into html table
   displayData ( myData );
}
</script>

<body>
<!-- #include virtual="~/shared/top.inc -->
<div class="header"><h2>ADO.NET Primer: Retrieving <b>OLEDB</b> Data Into a DataSet</h2></div>

<!-- #include virtual="~/shared/viewsrc_top.inc" -->
<hr size=1 width=92%>

<form runat="server">
<p align="center">
   <%= html %>
</p>
</form>


<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->

</body>
</html>