vs2010远程连接oracle数据库,VS2010 C# 如何连接Oracle 11g数据库

VS2010 C# 如何连接Oracle 11g数据库

VS2010 C# 如何连接Oracle 11g数据库

vs2010 c# 连接远程oracle 11g的数据库

需要安装ODTwithODAC1120320_32bit；

安装说明：

1.setup.exe

2.选择安装的产品(Oracle Client)而不是 (Oracle Server)

3.项目添加Oracle.DataAccess.dll的引用

4.Oracle.DataAccess.dll

例如：D:\app\dell\product\11.2.0\client_1\odp.net\bin\4文件夹下面

------

using Oracle.DataAccess.Client;

public string GetEmail(string id)

{

string strCon = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=orcl)));" + "User Id=id;Password=password;";

OracleConnection conn = new OracleConnection(strCon);

try

{

string sql = "select name from table where id=\'" + id+"\'";

//string sql = "select * from table";

OracleCommand com = conn.CreateCommand();

com.CommandText = sql;

conn.Open();

string result = Convert.ToString(com.ExecuteScalar());

//OracleDataAdapter oraDA = new OracleDataAdapter(com);

//DataSet ds = new DataSet();

//oraDA.Fill(ds);

//conn.Clone();

//DataTable dt = ds.Tables[0];

//string result = "";

//if (dt != null && dt.Rows.Count > 0)

//{

// foreach (DataRow dr in dt.Rows)

// {

// //string a = dr["a"].ToString();

// //string b = dr["b"].ToString();

// //string c = dr["c"].ToString();

// //string d = dr["d"].ToString();

// }

//}

return result;

}

catch (Exception ex)

{

return "no";

}

finally

{

conn.Close();

}

}

----

见图：

VS2010 C# 如何连接Oracle 11g数据库相关教程