CシャープでDBアクセス(Oracle)
using System; using System.Data; using Oracle.DataAccess.Client; class Example { OracleConnection con; void Connect() { con = new OracleConnection(); con.ConnectionString = "User Id=pkg_test5;Password=pkg_test5;Data Source=ijidb"; con.Open(); Console.WriteLine("Connected to Oracle"); Console.WriteLine(con.ServerVersion); } void execute() { string cmdQuery = "SELECT systimestamp(9) from dual"; // Create the OracleCommand object OracleCommand cmd = new OracleCommand(cmdQuery); cmd.Connection = con; cmd.CommandType = CommandType.Text; try { // Execute command, create OracleDataReader object OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { // Output Employee Name and Number Console.WriteLine("Systimestampe(9): " + reader.GetDateTime(0)); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { // Dispose OracleCommand object cmd.Dispose(); // Close and Dispose OracleConnection object con.Close(); con.Dispose(); } } void Close() { con.Close(); con.Dispose(); } static void Main() { Example example = new Example(); example.Connect(); example.execute(); example.Close(); } }