数据库连接方式

连接Oracle数据库
  1.使用Oracle.NET Data Provider（需要安装Oracle客户端）

 

//导入命名空间
using System.Data.OracleClient;

publicvoid Page_Load(Object sender,EventArgs e)
{
//设置连接字符串
string connstring =@"Data Source=oraclesample;User ID=oracleid;Password=oraclepwd;";
//实例化OracleConnection对象
OracleConnection conn =new OracleConnection(connstring);
//打开连接
connn.Open();
}

 

2.使用ODBC.NET Data Provider

//导入命名空间
using System.Data.Odbc;

publicvoid Page_Load(Object sender,EventArgs e)
{
//设置连接字符串
string connstring =@"Driver=Microsoft ODBC for Oracle;Server=oraclesample;Persisit Security Info=False;Trusted_Connection=yes;";
//实例化OracleConnection对象
OdbcConnection conn =new OdbcConnection(connstring);
//打开连接
connn.Open();
}

 

3.使用OLE DB.NET Data Provider

 

//导入命名空间
using System.Data.Oledb;

publicvoid Page_Load(Object sender,EventArgs e)
{
//设置连接字符串
string connstring =@"Provider=MSDAORA;Data Source=oraclesample;Persisit Security Info=False;Integrated Security=yes;";
//实例化OracleConnection对象
OleDbConnection conn =new OleDbConnection(connstring);
//打开连接
connn.Open();
}