新手！asp.net怎么连接ORACLE数据库？

[chin19870117]

asp.net怎么连接ORACLE数据库？
引用里面只看到有System.Data.SqlClient
找不到有System.Data.OracleClient

[wyman25]

http://www.zxbc.cn/html/20080408/33142.html
这里有各种连接字符串

[wyman25]

先添加引用：System.Data.OracleClient.dll

[wdzr_826]

右击引用，添加引用，里面找到System.Data.OracleClient添加进去，这样才能引入命名空间。

[IHandler]

访问Oracle数据库特别说明：
下载.NET支持Oracle附加组件oracle_net.msi
http://www.microsoft.com/downloads/details.aspx?familyid=4F55D429-17DC-45EA-BFB3-076D1C052524&displaylang=zh-cn
安装C:\Program Files\Microsoft.NET\OracleClient.Net
将该目录下System.Data.OracleClient.dll在项目中引用

连接字符串

[wuyq11]

选择引用，右键添加System.Data.OracleClient.dll
string connstring="Data Source=a;user=system;password=manager;";
OracleConnection conn=new OracleConnection(connstring);
或看看petshop里有操作oracle数据库操作类

[gaijf]

不用System.Data.OracleClient，用ODP.net

[axisloverster]

System.Data.OracleClient.dll

[mengzx0703]

还要添加DLL？学习！

[济南大飞哥]

想连就连，要连由自己

[pingmac]

public DataTable ExecuteSqlRead(string SqlString)
              {
                  OleDbCommand SqlCmd = new OleDbCommand();
                  SqlCmd.Connection = new OleDbConnection(ConfigurationSettings.AppSettings["OracleConnectString" value ="Provider=OraOleDb.Oracle.1;data source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=61.139.93.80)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)));User Id=tlbb;Password=JC4KQO1EJPTLBB;Persist Security Info=True;"]);
                  SqlCmd.CommandText = SqlString;
                  SqlCmd.CommandType = CommandType.Text;
                  OleDbDataAdapter SqlAd = new OleDbDataAdapter(SqlCmd);
                  DataSet Rs = new DataSet();
                  SqlAd.Fill(Rs);
                  return Rs.Tables[0];
              }

              /// 执行SQL语句
              public Boolean ExecuteSqlWrite(string SqlString)
              {
                  OleDbCommand SqlCmd = new OleDbCommand();
                  SqlCmd.Connection = new OleDbConnection(ConfigurationSettings.AppSettings["OracleConnectString" value ="Provider=OraOleDb.Oracle.1;data source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=61.139.93.80)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)));User Id=tlbb;Password=JC4KQO1EJPTLBB;Persist Security Info=True;"]);
                  SqlCmd.CommandText = SqlString;
                  SqlCmd.CommandType = CommandType.Text;
                  SqlCmd.Connection.Open();
                  SqlCmd.ExecuteNonQuery();
                  SqlCmd.Connection.Close();
                  return true;

              }