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();
}
}
----
见图: