使用dll的oracle连接 [英] oracle connection using dll

问题描述

hii乡亲
我想使用dll与oracle数据库建立连接，这是代码

hii folks
i want to create connection with oracle database using dll here is the code

OleDbConnection con = new OleDbConnection("connection string");
           OleDbCommand cmd = con.CreateCommand();
           cmd.CommandText = "select sb_no from shipbill where sb_no=''4790421''";
           con.Open();
           OleDbDataReader dr = cmd.ExecuteReader();
           while (dr.Read())
           {
               textBox2.Text = dr["sb_no"].ToString();
           }

如何在应用程序中使用它

或

从哪里可以获取所需的dll
请帮助我
提前thanx ...祝您有美好的一天...

how can i use it in my application

OR

from where can i get the desired dll
plz help me
thanx in advance...have a nice day...

推荐答案

如果可能，请使用ODP.NET代替OleDb: ^ ]

使用该库，您可以使用Oracle数据库的所有功能，并且由于不受ole db库的限制，因此编码效率将大大提高.

使用odp的示例中需要的类为:

• OracleConnection [ OracleCommand [OracleDataReader [

Instead of using OleDb, if possible, try using ODP.NET: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html[^]

With that library you can use all the features of the Oracle database and the coding will be much more efficient because you are not restricted by the ole db library.

Classes you will need in your example with odp are:

• OracleConnection[^]
• OracleCommand[^]
• OracleDataReader[^]

你好朋友..
这可能会帮助您...

http://download.oracle.com/docs/cd/B19306_01/win. 102/b14307/OracleConnectionClass.htm [ ^ ]

http://msdn.microsoft.com/en-us/library/xexk8kx3％28v = vs.71％29.aspx [ ^ ]


使用C#即时Oracle [ http://www.nodevice.com/dll/O/page7.html [ ^ ]

http://www.dlldll.com/system.data.oracleclient.dll_download.html [ ^ ]

Hello Friend..
This will might help you...

http://download.oracle.com/docs/cd/B19306_01/win.102/b14307/OracleConnectionClass.htm[^]

http://msdn.microsoft.com/en-us/library/xexk8kx3%28v=vs.71%29.aspx[^]


Instant Oracle Using C#[^]

You can download dll from here

http://www.nodevice.com/dll/O/page7.html[^]

http://www.dlldll.com/system.data.oracleclient.dll_download.html[^]

这篇关于使用dll的oracle连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！