C# - Oracle数据库连接方法

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;

namespace OraWinApp
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
string myConnString = "data source=192.168.30.9;user id=test;password=1";
OracleConnection myConnection = new OracleConnection(myConnString);

OracleCommand catCMD = myConnection.CreateCommand();
catCMD.CommandText = " SELECT T.P_NM,T.C_NM,T.A_NM,T.FULL_NAME FROM T_ZIP_DISTRICT_PHONECODE T ";

myConnection.Open();

OracleDataReader myReader = catCMD.ExecuteReader();

while (myReader.Read())
{
Console.WriteLine("-{0}-{1}-{2}-{3}", myReader.GetString(0), myReader.GetString(1), myReader.GetString(2), myReader.GetString(3));
}

myReader.Close();

myConnection.Close();

}
}
}

注：添加对System.Data.OracleClient的引用。