C#连接Oracle数据库

时间:2026-02-16 02:56:53

1、下载“Oracle.ManagedDataAccess.dll”;

2、在工程中添加引用“Oracle.ManagedDataAccess.dll”;

3、引用命名空间“using Oracle.ManagedDataAccess.Client;”

4、连接数据库代码如下:

public bool Connect(string hostaddress, string servername, string uid, string pwd)

{

           string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="+ hostaddress +")(PORT=1521))(CONNECT_DATA=(SERVICE_NAME="+ servername +")));Persist Security Info=True;User ID="+ uid +";Password="+ pwd +";";

            OracleConnection conn = new OracleConnection(connString);

            conn.Open();

            if(conn.State==ConnectionState.Open)

            {

                conn.Close();

                return true;

            }

            else

            {

                return false;

            }

}

© 2026 途途旅游
信息来自网络 所有数据仅供参考
有疑问请联系站长 site.kefu@gmail.com