C#连接oracle

Question

难道不是一样吗
先装上Oracle.net组件

Answer 1

oracle连接字符串
String ConnectionString ="Provider=SQLOLEDB;Data Source="+mSqlServerName+";Initial Catalog="+mSqlDbName+";User ID="+mSqlUserId+"; password="+mSqlPwd+";Persist Security Info=False";
如果你希望用类似于sqlclient的方法要安装：Microsoft .NET Data Provider for Oracle EN.msiUsing C#:using System.Data.OracleClient;
 
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
                               "Integrated Security=SSPI";
oOracleConn.Open();
 
Using VB.NET:Imports System.Data.OracleClient
 
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "Data Source=Oracle8i;" & _
                               "Integrated Security=SSPI";
oOracleConn.Open()http://www.csdn.net/Develop/read_article.asp?id=16437

Answer 2

Microsoft .NET Data Provider for Oracle EN.msi那里有

Answer 3

微软网站上有Microsoft .NET Data Provider for Oracle EN.msi

Answer 4

string sStr="select * from table1";
System.Data.OleDb.OleDbConnection objconnect=new System.Data.OleDb.OleDbConnection(strconnect);
System.Data.OleDb.OleDbCommand objcommand=new System.Data.OleDb.OleDbCommand(strselectCode,objconnect);
System.Data.OleDb.OleDbDataReader objdatareader ;
objconnect.Open();
objdatareader=objcommand.ExecuteReader();
while (objdatareader.Read()==true)
......
objdatareader.Close();
objconnect.Close();

Answer 5

有错误不好意思！！！
string sStr="select * from table1";
System.Data.OleDb.OleDbConnection objconnect=new System.Data.OleDb.OleDbConnection(strconnect);
System.Data.OleDb.OleDbCommand objcommand=new System.Data.OleDb.OleDbCommand(sStr,objconnect);
System.Data.OleDb.OleDbDataReader objdatareader ;
objconnect.Open();
objdatareader=objcommand.ExecuteReader();
while (objdatareader.Read()==true)
......
objdatareader.Close();
objconnect.Close();