ASP.NET Tutorial/ADO.net Database/Oracle

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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>

Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/Oracle&oldid=2672»