Asp.net 访问Oracle的例子

最新推荐文章于 2024-10-28 09:59:57 发布

aloxy

最新推荐文章于 2024-10-28 09:59:57 发布

阅读量872

点赞数

分类专栏： ORACLE 文章标签： asp.net oracle redirect compilation authentication assembly

本文链接：https://blog.csdn.net/aloxy/article/details/6266080

版权

ORACLE 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

测试 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(); } } }