一、通过System.Data.OracleClient(需要安装Oracle客户端并配置tnsnames.ora)
1、添加命名空间System.Data.OracleClient引用
2、在代码中加入引用using System.Data.OracleClient;
3、连接代码
using System.Data.OracleClient;
public void Init()
{
try
{
string str_conn = "Data Source=PSONTEST;User Id=reader;Password=reader;Persist Security Info=True;Unicode=True";
using (OracleConnection my_conn = new OracleConnection(str_conn))
{
string str_com = "select * from 数据库表;
my_conn.Open();
using (OracleCommand my_com = new OracleCommand(str_com, my_conn))
{
OracleDataReader my_reader = my_com.ExecuteReader();
while (my_reader.Read())
{
//以下两种方法得到所需值
string sID = my_reader.GetString(0);
int sGID = my_reader["GROUPID"].ToString().Trim();
}
}
my_conn.Close();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
二、无需安装oracle客户端
1、下载ODAC
下载地址1:http://download.csdn.net/detail/easyboot/9456476
下载地址2:http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html
2、将下载的文件解压之后找到Oracle.ManagedDataAccess.dll
在此路径下:E:\ODP.NET_Managed_ODAC12cR4\odp.net\managed\common
3、将找到的dll文件拷贝到你的项目目录下,并引用进来即可
4、在代码中加入引用
using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Types;
5、连接测试代码
using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Types;
public void Init()
{
try
{
string str_conn = "User Id=/*数据库的id*/;Password=/*数据库的password*/;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=/*ip*/)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=/*数据库name*/)))";
using (OracleConnection my_conn = new OracleConnection(str_conn))
{
string str_com = "select * from 数据库表;
my_conn.Open();
using (OracleCommand my_com = new OracleCommand(str_com, my_conn))
{
OracleDataReader my_reader = my_com.ExecuteReader();
while (my_reader.Read())
{
//以下两种方法得到所需值
string sID = my_reader.GetString(0);
int sGID = my_reader["GROUPID"].ToString().Trim();
}
}
my_conn.Close();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}