ASP.NET Tutorial/ADO.net Database/Oracle
Connect to Oracle with OracleConnection
<source lang="csharp">
<%@ Page Language="C#" debug="true" %> <%@ Import Namespace="System.Data.OracleClient" %> <script runat="server"> void Page_Load(Object sender, EventArgs e) {
String connectString = "Data Source=Oracle-Test;User ID=user;Password=pass"; OracleConnection myConn = null; try { myConn = new OracleConnection( connectString ); myConn.Open(); lblConnectInfo.Text = "Connection successful!"; } catch { lblConnectInfo.Text = "Connection failed!"; } finally { if (myConn != null) myConn.Close(); }
} </script> <html>
<head> <title></title> </head> <body> <form id="form1" method="post" runat="server"> This page simply tries (and fails) to open an Oracle connection. <asp:Label id="lblConnectInfo" runat="server"></asp:Label> </form> </body>
</html></source>
System.Data.OracleClient for Oracle
<source lang="csharp">
<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">
<title>Connect Oracle</title>
</head> <body>
<form id="form1" runat="server">
<asp:GridView id="grdOrders" DataSourceID="srcOrders" Runat="server" /> <asp:SqlDataSource id="srcOrders" ProviderName="System.Data.OracleClient" SelectCommand="SELECT * FROM Orders" ConnectionString="Data Source=OracleDB;Integrated Security=yes" Runat="server" />
</form>
</body> </html></source>