protected void Page_Load ( Object Src, EventArgs e ) {
   // specify the data source
   SqlConnection myConn = new SqlConnection (
      "server=localhost; trusted_connection=yes; database=northwind" );

   // define the command query
   String query = "SELECT ProductName, ProductDescription FROM Products";
   SqlCommand myCommand = new SqlCommand ( query, myConn );

   // open the connection and instantiate a datareader
   myConn.Open ( );
   SqlDataReader myReader = myCommand.ExecuteReader ( );

   // display datareader contents into html table
   // first open the table and set up the table headers
   html += "<table cellspacing=1 class='data' width=90%>";
   html += "<tr>";
   html += "<th>Product Name</th>";
   html += "<th>Description</th>";
   html += "</tr>";

   // loop thru the reader
   while ( myReader.Read ( ) ) {
      html += "<tr>";
      html += "<td>" + myReader.GetString ( 0 ) + "</td>";
      html += "<td>" + myReader.GetString ( 1 ) + "</td>";
      html += "</tr>";
   }

   // close the table
   html += "</table>";

   // close the reader and the connection
   myReader.Close ( );
   myConn.Close ( );
}
</script>

protected sub Page_Load ( byVal Src as Object, byVal E as EventArgs )
   ' specify the data source
   dim myConn as new SqlConnection ( & _
      "server=localhost; trusted_connection=yes; database=northwind" )

   ' define the command query
   dim query as String = "SELECT ProductName, ProductDescription FROM Products"
   dim myCommand as new SqlCommand ( query, myConn )

   ' open the connection and instantiate a datareader
   myConn.Open ( )
   dim myReader as SqlDataReader = myCommand.ExecuteReader ( )

   ' display datareader contents into html table
   ' first open the table and set up the table headers
   html &= "<table cellspacing=1 class='data' width=90%>"
   html &= "<tr>"
   html &= "<th>Product Name</th>"
   html &= "<th>Description</th>"
   html &= "</tr>"

   ' loop thru the reader
   while myReader.Read ( )
      html &= "<tr>"
      html &= "<td>" + myReader.GetString ( 0 ) + "</td>"
      html &= "<td>" + myReader.GetString ( 1 ) + "</td>"
      html &= "</tr>"
   end while

   ' close the table
   html &= "</table>"

   ' close the reader and the connection
   myReader.Close ( )
   myConn.Close ( )
end sub
</script>