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的引用。