1、添加引用,路径:
“C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.OracleClient.dll”
2、引用命名空间 using System.Data.OracleClient;
3、 //定义连接通道的字符串
//连接字符串:“oracle配置信息;用户名;密码”
String connection = “Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME= orcl)));User Id=pms; Password=project”;
//定义连接通道对象
OracleConnection conn = new OracleConnection(connection);
//打开通道
conn.Open();
//关闭通道
conn.Close();
Console.WriteLine("连接成功");
Console.ReadKey();