?

1.源代碼

string connString = "User ID=scott;Password=yanhong;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = yanhong)))";
OracleConnection conn = new OracleConnection(connString);
try
{
conn.Open();
OracleCommand com=new OracleCommand("select * from emp ",conn);
DataSet ds=new DataSet();
OracleDataAdapter oda = new OracleDataAdapter(com);
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
MessageBox.Show(conn.State.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}

?

2.可能會(huì)出現(xiàn)“嘗試加載 Oracle 客戶端庫時(shí)引發(fā) BadImageFormatException。如果在安裝 32 位 Oracle 客戶端組件的情況下以 64 位模式運(yùn)行，將出現(xiàn)此問題。“問題、

解決方法：

　　將項(xiàng)目屬性的目標(biāo)平臺(tái)改成64位即可

oracle連接數(shù)據(jù)