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



1.项目右击:选择"添加引用",添加Oracle.Data.Access.dll (之前需要安装Oracle-Client,具体参见:http://www.oracle.com/technetwork/articles/dotnet/vs2010-oracle-dev-410461.html)

2.使用代码:

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();

        }
    }
}