asp.net.ph Source Code Viewer

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

<html>
<head>
<title>OleDbConnection Example</title>
<link rel="stylesheet" href="/shared/netdemos.css">

<script language="C#" runat="server">
string html;

protected void Page_Load ( Object src, EventArgs e ) {
   // specify the data source
   OleDbConnection myConn = new OleDbConnection (
      "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + 
      Server.MapPath ( "~/app_data/dbtutor.mdb" ) );
   // open the data connection
   myConn.Open ( );

   // retrieve properties of the connection object
   html += "<table cellspacing=1 class=data width=90%>";

   html += "<tr><td><b>ConnectionString</b></td>";
   html += "<td>" + myConn.ConnectionString + "</td></tr>";

   html += "<tr><td><b>ConnectionTimeout</b></td>";
   html += "<td>" + myConn.ConnectionTimeout + "</td></tr>";

   html += "<tr><td><b>DataSource</b></td>";
   html += "<td>" + myConn.DataSource + "</td></tr>";

   html += "<tr><td><b>Provider</b></td>";
   html += "<td>" + myConn.Provider + "</td></tr>";

   html += "<tr><td><b>ServerVersion</b></td>";
   html += "<td>" + myConn.ServerVersion + "</td></tr>";

   html += "<tr><td><b>State</b></td>";
   html += "<td>" + myConn.State + "</td></tr>";

   html += "</table>";

   // close the data connection
   myConn.Close ( );
}
</script>
</head>

<body>
<!-- #include virtual="~/shared/top.inc" -->

<div class="header"><h2>ADO.NET Primer: <b>OleDbConnection</b> Example</h2></div>

<hr size=1 width=92%>

<center>

<p><i>Properties of current <b>OleDbConnection</b> object</i></p>

<%= html %>

</center>

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

</body>
</html>