.net 连接ORACLE 数据库的例子
利用 System.Data.OracleClient.Dll 的组件进行连接：
首先配置WebConfig 文件；
<connectionStrings>
<add name="oracleconn" connectionString="Data Source="";User ID=ryq;Password=123456" providerName="System.Data.OracleClient"/>
</connectionStrings>
然后添加System.Data.OracleClient.Dll 的引用才可以在页面中写代码using System.Data.OracleClient;
System.Data.OracleClient.Dll 常用的类：
System.Data.OracleClient.OracleConnection;
System.Data.OracleClient.OracleConnectionStringBuilder;
System.Data.OracleClient.OracleCommand;
System.Data.OracleClient.OracleCommandBuilder;
System.Data.OracleClient.OracleDataAdapter;
System.Data.OracleClient.OracleDataReader;
System.Data.OracleClient.OracleTransaction;
System.Data.OracleClient.OraclePerameter;
System.Data.OracleClient.OracleString;
System.Data.OracleClient.OracleType;
//前台显示
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Oracle连接数据测试</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
显示数据测试：<asp:Button ID="Btn_Search" runat="server" OnClick="Btn_Search_Click" Text="查询"
Width="64px" /><br />
<br />
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Height="184px"
Width="872px">
<Columns>
<asp:BoundField DataField="emporium_id" HeaderText="客户编号" SortExpression="客户编号" />
<asp:BoundField DataField="item_no" HeaderText="项次" SortExpression="项次" />
<asp:BoundField DataField="recipients" HeaderText="联系地址" SortExpression="联系地址" />
<asp:BoundField DataField="delive_address" HeaderText="送货地址" SortExpression="送货地址" />
</Columns>
</asp:GridView>
</div>
<asp:Label ID="Label1" runat="server" Height="24px" Text="Label" Width="688px"></asp:Label>
</form>
</body>
</html>
//后台代码实现：
using System;
using System.Data;
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;
using System.Data.OracleClient; //要引用的类库
public partial class _Default : System.Web.UI.Page
{
public System.Data.OracleClient.OracleConnection objConn; //声明一个OracleConnection对象
public System.Data.OracleClient.OracleCommand objCmd; //声明一个OracleCommand对象
public System.Data.OracleClient.OracleDataAdapter objAdp; //数据库适配器
public System.Data.DataSet dset; //DataSet 用于数据填充
//页面加载
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "";
string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["oracleconn"].ConnectionString;
objConn = new OracleConnection(strconn);
}
//查询按钮设计
protected void Btn_Search_Click(object sender, EventArgs e)
{
try
{
string StrSql = "select * from pub_address";
objConn.Open();
objCmd = new OracleCommand(StrSql, objConn);
objAdp = new OracleDataAdapter(objCmd);
dset = new DataSet();
objAdp.Fill(dset);
objConn.Close();
GridView1.DataSource = dset;
GridView1.DataBind();
}
catch(Exception ex)
{
Label1.Text = ex.ToString();
return;
}
}
}
//以上简单实现从Oracle 中查询数据显示GridView 中， 当然重要的是数据库如何连接的部分。
