오라클 접속

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OracleClient;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            String strcon = "Data Source=SEUNGWON;User ID=scott;Password=tiger";
            String query = "INSERT INTO address VALUES(:id,:name,:addr)";
            OracleConnection conn = null;
            try
            {
                conn = new OracleConnection(strcon);
                conn.Open();
                OracleCommand comm = new OracleCommand(query, conn);
                //파라미터의 타입정의
                comm.Parameters.Add(":id", OracleType.Number);
                comm.Parameters.Add(":name", OracleType.VarChar);
                comm.Parameters.Add(":addr", OracleType.VarChar);
                //파라미터의 값을 지정
                comm.Parameters[":id"].Value = 2;
                comm.Parameters[":name"].Value = "승원";
                comm.Parameters[":addr"].Value = "대전시";
                //쿼리 실행
                int count = comm.ExecuteNonQuery();
                Console.WriteLine("{0}행이 적용되었습니다.", count);
            }
            catch (OracleException e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                conn.Close();
                SelectMethod();
            }
        }
            static void SelectMethod()
            {
                OracleConnection conn = null;
                String strcon = "Data Source = LES;User ID= scott;Password = tiger";
                String query = "SELECT * FROM address";
                try
                {
                    conn = new OracleConnection(strcon);
                    conn.Open();
                    OracleCommand comm = new OracleCommand(query, conn);
                    OracleDataReader re = comm.ExecuteReader();
                    //한생씩 읽어온다.
                    while (re.Read())
                    {
                        //한행의 컬럼수 만큼 읽는다.
                        Console.WriteLine(re[0].ToString() + "\t"
                            + re[1].ToString() + "\t"
                            + re[2].ToString() + "\n");
                    }
                }
                catch (OracleException e)
                {
                    Console.WriteLine(e.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        
    }
}