간단하게 C# & 오라클 연동하기

using System; using System.Data; using Oracle.DataAccess.Client; namespace orc_test { class Program { static void Main(string[] args) { string oradb = "User Id=System;Password=1234;Data Source=;"; OracleConnection conn = new OracleConnection(oradb); conn.Open(); string sql = "SELECT * FROM TEST1"; OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Console.Write(dr[0].ToString() + "\t"); Console.Write(dr.GetString(1).ToString() + "\t" + dr.GetString(2) + "\t"); Console.Write(dr[3].ToString() + "\t" + dr.GetString(4) + "\t" + dr.GetString(5)); } conn.Clone(); conn.Dispose(); Console.ReadLine(); } } }