ASP.NET Tutorial/ADO.net Database/Oracle

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

Connect to Oracle with OracleConnection

<%@ 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>


System.Data.OracleClient for Oracle

<%@ 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">
    <div>
    <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" />
    </div>
    </form>
</body>
</html>
Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/Oracle&oldid=2672»