C# 免客户端访问Oracle的DLL

代码示例:

OracleConnection con = new OracleConnection();
              con.ConnectionString ="user id=username;password=password;data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=servicename.oracle.com)))";
               con.Open();
      
                 OracleCommand cmd = new OracleCommand();
                 cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = "select * from students";
                cmd.Connection = con;
      
                OracleDataAdapter da = new OracleDataAdapter();
                da.SelectCommand = cmd;
                DataSet ds = new DataSet();
                da.Fill(ds);
     
               
                
                con.Close();
                da.Dispose();
                cmd.Dispose();
                con.Dispose();

 

 

注:

C#的版本要求 .NET Framework 4.0才能引入这个DLL文件,否则会报错

DLL文件下载地址(64位):https://pan.baidu.com/s/17qm0ooNvP2ZHAOHYVUV0-g

Enjory :)

 

posted @ 2019-02-25 11:13  bigdog  阅读(121)  评论(0编辑  收藏  举报