http://msdn.microsoft.com/zh-cn/library/cc437980(VS.71).aspxpublic void ConnectToOracle() { OracleClient.OracleConnection conn = new OracleClient.OracleConnection (); // TODO: Modify the connection string and include any // additional required properties for your database. conn.ConnectionString = "Data Source=" + "<oracle data source name>;Integrated Security=yes"; try { conn.Open(); // Insert code to process data. } catch (Exception ex) { MessageBox.Show("Failed to connect to data source"); } finally { conn.Close(); } }
using System; using System.Data; //要添加System.Data.OracleClient.dll引用 using System.Data.OracleClient;class OracleDemo { static void Main(string[] args) { OracleConnection cn = new OracleConnection("Data Source=wish;uid=xxx;pwd=xxx"); OracleCommand cmd = new OracleCommand("Select ... FROM ...", cn); cn.Open(); OracleDataReader dr = cmd.ExecuteReader(); while(dr.Read()) { Console.WriteLine("\t{0}\t{1}", dr.GetInt32(0), dr.GetString(1)); }
{
OracleClient.OracleConnection conn =
new OracleClient.OracleConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = "Data Source=" +
"<oracle data source name>;Integrated Security=yes";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
using System.Data;
//要添加System.Data.OracleClient.dll引用
using System.Data.OracleClient;class OracleDemo
{
static void Main(string[] args)
{
OracleConnection cn = new OracleConnection("Data Source=wish;uid=xxx;pwd=xxx");
OracleCommand cmd = new OracleCommand("Select ... FROM ...", cn); cn.Open(); OracleDataReader dr = cmd.ExecuteReader(); while(dr.Read())
{
Console.WriteLine("\t{0}\t{1}", dr.GetInt32(0), dr.GetString(1)); }
dr.Close();
cn.Close();
}
}
那你就会连oracle了
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;