c# 64 oracle数据库,C#连接Oracle数据库的方法

最新推荐文章于 2021-04-13 19:39:41 发布

Jun Duanmu

最新推荐文章于 2021-04-13 19:39:41 发布

阅读量128

点赞数

文章标签： c# 64 oracle数据库

usingSystem;2 usingSystem.Data;3 usingOracle.ManagedDataAccess.Client;4

5 namespaceODP.NET6 {7 classProgram8 {9 static void Main(string[] args)10 {11 OracleConnection conn = null;12 try

13 {14 conn =OpenConn();15 var cmd =conn.CreateCommand();16 cmd.CommandText = "select * from s_awb_master where rownum=1";17 cmd.CommandType =CommandType.Text;18 var reader =cmd.ExecuteReader();19 while(reader.Read())20 {21 Console.WriteLine(string.Format("AwbPre:{0},AwbNo:{1}", reader["AwbPre"], reader["AwbNo"]));22 }23 }24 catch(Exception ex)25 {26 Console.WriteLine(ex.Message);27 }28 finally

29 {30 CloseConn(conn);31 }32 Console.Read();33 }34

36 staticOracleConnection OpenConn()37 {38 OracleConnection conn = newOracleConnection();39 conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***.***.***.***)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=***)));Persist Security Info=True;User ID=***;Password=***;";40 conn.Open();41 returnconn;42 }43

44 static voidCloseConn(OracleConnection conn)45 {46 if (conn == null) { return; }47 try

48 {49 if (conn.State !=ConnectionState.Closed)50 {51 conn.Close();52 }53 }54 catch(Exception e)55 {56 Console.WriteLine(e.Message);57 }58 finally

59 {60 conn.Dispose();61 }62 }63 }64 }

C#连接Oracle数据库的方法

标签：oracl dll desc 类库 detail x86 字符串 row logs

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉本文系统来源：https://www.cnblogs.com/lgx5/p/12631454.html