VS2010 VS2012 如何连接Oracle 11g数据库

1、下载链接Oracle 11g所需的驱动ODTwithODAC1120320_32bit，下载链接为http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

2、安装ODTwithODAC1120320_32bit，安装过程中选择安装产品是只需要选择Oracle Client即可

3、启动VS2010（个人比较钟情于10版），新建一个winform项目

4、向窗体设计界面托一个按钮和一个数据表格视图控件

5、添加Oracle.DataAccess.dll引用，然后在按钮事件下写入如下代码

string connectionString;            string queryString;

            // 连接字符串1            connectionString = "Data Source=192.168.1.111/ORCLDBTEST;User ID=SYSTEM;PassWord=sa";            // 连接字符串2            //connectionString = "Data Source=(DESCRIPTION="+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=1521))" +             //"(CONNECT_DATA=(SERVICE_NAME=ORCLDBTEST)));"+ "User Id=SYSTEM;Password=sa;";            queryString = "SELECT * FROM TESTTB";

            OracleConnection myConnection = new OracleConnection(connectionString);            OracleCommand myORACCommand = myConnection.CreateCommand();            myORACCommand.CommandText = queryString;            myConnection.Open();            OracleDataAdapter oraDA = new OracleDataAdapter(myORACCommand);            DataSet ds = new DataSet();            oraDA.Fill(ds);            myConnection.Close();            DataTable dtbl = ds.Tables[0];            this.dataGridView1.DataSource = dtbl;

6、按下熟悉的F5启动程序即可获取到数据库表的数据了