oracleÎÞ·¨½âÎöÁ¬½Ó×Ö·û´®£¬Çë½Ì

C# code:
string StrConnection = "Server=127.0.0.1;Data Source=kagami;User ID=system;Password=kagami;";
string strCommand = "SELECT id as ²úÆ·±àºÅ, name as ²úÆ·Ãû×Ö from test";
OracleConnection OraCon = new OracleConnection(StrConnection);
try
{
OraCon.Open(); ///ÎÞ·¨½âÎö
OracleCommand OraCommand = new OracleCommand(strCommand, OraCon);
OracleDataReader Reader = OraCommand.ExecuteReader();
while (Reader.Read())
{
Console.WriteLine("²úÆ·±àºÅ:{0}, ²úÆ·Ãû×Ö:{1}", Reader[0], Reader[1]);
}
}
finally
{
OraCon.Close();
}

---

¿´¿´ÊDz»ÊÇÁ¬½Ó×Ö·û´®´íÁË 
ÊÔÏÂÕâ¸ö°É 

"Data Source=Êý¾Ý¿âÃû;Persist Security Info=True;User ID=Óû§Ãû;Password=ÃÜÂë;Unicode=True";

---

ÒýÓÃ

±¾µØORACLE¿Í»§¶ËÅäÖÃ
¼ì²étnsnames.ora
sql plusÖÐÓû§Ãû¡¢ÃÜÂë¡¢Êý¾Ý¿â
ÊÇ·ñÓë×Ö·û´®Ò»ÖÂ

ÍƼö

---

¼ÌÐøÇóÖú£¬»¹ÊǸ㲻¶¨£¬sqlplus,plsqldeverloper¶¼¿ÉÁ¬½Ó
tnsnames.ora:# tnsnames.ora Network Configuration File: E:\oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

KAGA