菜鸟求助 C#联接oracle
联到ORACLE数据库,以下代码请各位大侠帮忙看看,小弟谢谢了
- C# code
using System.Data.OracleClient;private void Button1_Click(object sender, System.EventArgs e){string ConnectionString="Data Source=192.16.1.20;user=hrp;password=hrp;";OracleConnection conn=new OracleConnection(ConnectionString);try{conn.Open();OracleCommand cmd=conn.CreateCommand();cmd.CommandText="select * from MyTable";OracleDataReader odr=cmd.ExecuteReader();while(odr.Read()) {Response.Write(odr.GetOracleString(1).ToString());}odr.Close();}catch(Exception ee){Response.Write(ee.Message);}finally{conn.Close();}}
编译报错,说using system.data中不存在类型或命名空间oracleclent???
[解决办法]
记得给分
[解决办法]
在程序中,右键添加System.Data.OracleClient引用,
[解决办法]
引用 System.Data.OracleClient.dll
[解决办法]
string ConnectionString="Data Source=192.16.1.20;
DataBase = '数据库名';user=hrp;password=hrp;";