오라클 연결 C#

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 WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

        private void ultraButton1_Click(object sender, EventArgs e)

        {

            string qry = "select * from C_COMMON_CD";

            string OraConn = "Data Source=ORCL;User ID=uduser;Password=hmc1234";

 

            DataSet ds = new DataSet();

 

            OracleConnection conn = new OracleConnection(OraConn);

            conn.Open();

 

            OracleDataAdapter oda = new OracleDataAdapter(qry, conn);

            oda.Fill(ds);

            conn.Close();

 

            ultraGrid1.DataSource = ds.Tables[0];

 

            //qry = "update C_COMMON_CD set CODE_OPT_05 = 'aaa'";

            //conn.Open();

            //OracleCommand cm = new OracleCommand(qry, conn);

            //cm.ExecuteNonQuery();

            //conn.Close();

 

        }

    }

}