Asp.net 访问Oracle的例子

最新推荐文章于 2021-04-13 01:08:24 发布

原创最新推荐文章于 2021-04-13 01:08:24 发布 · 907 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #oracle #redirect #compilation #authentication #assembly

ORACLE 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一种使用ASP.NET2.0进行Web开发时与Oracle9数据库集成的方法。通过配置web.config文件引入Oracle客户端，并展示了如何在默认页面default.aspx.cs中连接Oracle数据库并读取数据。

测试 Oracle9+asp.net 2.0。

web.config

<?xml version="1.0"?>  <configuration> <appSettings> <add key="DB" value="Oracle"></add> <add key="ConnectString" value="Data Source=ORCL;User ID=username;password=password;"></add> </appSettings> <connectionStrings/> <system.web>  <compilation debug="true"> <assemblies> <add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></compilation>  <authentication mode="Windows"/>  </system.web> </configuration>

default.aspx.cs

using System; using System.Data; using System.Data.OracleClient; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { string ConnectString = System.Configuration.ConfigurationManager.AppSettings["ConnectString"]; OracleConnection conn = new OracleConnection(ConnectString); if (conn.State != ConnectionState.Open) { conn.Open(); } try { OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "select * from web.news order by web.news.id desc"; OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Response.Write("<a href="read.aspx?id=" + dr.GetOracleValue(0) + "" mce_href="read.aspx?id=" + dr.GetOracleValue(0) + "">" + dr.GetOracleString(1) + "</a><br/>"); } dr.Close(); } catch (Exception ee) { Response.Write(ee.Message.ToString()); } finally { conn.Close(); } } }