在vs2010下使用C#连接Oracle数据库

1.项目右击:选择"添加引用",添加Oracle.Data.Access.dll (之前需要安装Oracle-Client,具体参见:http://www.oracle.com/technetwork/articles/dotnet/vs2010-oracle-dev-410461.html)  我的位置在  D:\app\zhuzhipeng\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll  为参考

2.

1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
5. using Oracle.DataAccess.Client;
7. namespace testConnectionOracle
8. {
9. class Program
10. {
11. static void Main(string[] args)
12. {
13. string connectionString;
14. string queryString;
16. connectionString = "Data Source=60.217.72.134/orcl;User ID=**;PassWord=**";
18. queryString = "SELECT * FROM test";
20. OracleConnection myConnection = new OracleConnection(connectionString);
22. OracleCommand myORACCommand = myConnection.CreateCommand();
24. myORACCommand.CommandText = queryString;
26. myConnection.Open();
28. OracleDataReader myDataReader = myORACCommand.ExecuteReader();
30. myDataReader.Read();
32. Console.WriteLine("id: " + myDataReader["id"]);
34. myDataReader.Close();
36. myConnection.Close();
38. }
39. }
40. }

using System;using System.Collections.Generic;using System.Linq;using System.Text;using Oracle.DataAccess.Client;namespace testConnectionOracle{    class Program    {        static void Main(string[] args)        {            string connectionString;            string queryString;            connectionString = "Data Source=60.217.72.134/orcl;User ID=**;PassWord=**";            queryString = "SELECT * FROM test";            OracleConnection myConnection = new OracleConnection(connectionString);            OracleCommand myORACCommand = myConnection.CreateCommand();            myORACCommand.CommandText = queryString;            myConnection.Open();            OracleDataReader myDataReader = myORACCommand.ExecuteReader();            myDataReader.Read();            Console.WriteLine("id: " + myDataReader["id"]);            myDataReader.Close();            myConnection.Close();        }    }}