[Oracle][C#]OracleCommand.ExecuteReader 메서드

[Oracle][C#]OracleCommand.ExecuteReader 메서드

< 발취 >

-- https://msdn.microsoft.com/ko-kr/library/ab4kxd8h(v=vs.110).aspx

< C# 소스 >

// 네임스페이스 System.Data.OracleClient public void CreateMyOracleDataReader(string queryString, string connectionString) { using (OracleConnection connection = new OracleConnection(connectionString)) { OracleCommand command = new OracleCommand(queryString, connection); //command .CommandText = "SQL문 또는 프로시저"; //member 테이블 //command .CommandType = CommandType.Text; connection.Open(); OracleDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { Console.WriteLine(reader.GetValue(0)); } } finally { reader.Close(); } } }