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

来源：互联网发布：lol黑色玫瑰网络波动编辑：程序博客网时间：2024/06/04 08:52

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

0 0