Question

C# 连接 Oracle 10g 的 连接语句怎么写

Answer 1

使用ado的方法

using System.Data.OracleClient;

 

string constr_qzj= "Password=sjcjcj;User ID=sjcjcj;Data Source=orcl;Persist Security Info=True";
OracleConnection con_qzj = null;
OracleDataAdapter da_qzj = null;
DataTable dt = null;
try
{
con_qzj = new OracleConnection(constr_qzj);
con_qzj.Open();
dt = new DataTable();
da_qzj = new OracleDataAdapter("select * from 表A",con_qzj);
da_qzj .Fill(dt);//去除数据到datetable
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
//释放对象
if (con_qzj!=null)
if (con_qzj.State == ConnectionState.Open)
{
con_qzj.Close();
}
con_qzj = null;
dt = null;
da_qzj = null;
}

可以参考下这个方法。

Answer 2

请问你用的ADO.NET么？还是ODP.NET？
两种的连接字符串不一样的

追问

static string sql = "Data Source=ORCL;Persist Security Info=True;Provider=OraOLEDB.Oracle;User ID=quanchenghan;Password=quan123;Unicode=True";

追答

呵呵，是ADO.NET

Answer 3

public static string connectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=主机)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=数据库名)));User Id=用户名;Password=密码;";

追问

static string sql = "Data Source=ORCL;Persist Security Info=True;Provider=OraOLEDB.Oracle;User ID=quanchenghan;Password=quan123;Unicode=True";