Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static string GetConnectionString()
- {
- String connString = "host= serverName;database=myDatabase;uid=userName;pwd=passWord";
- return connString;
- }
- private static void ConnectingToOracle()
- {
- string connectionString = GetConnectionString();
- using (OracleConnection connection = new OracleConnection())
- {
- connection.ConnectionString = connectionString;
- connection.Open();
- Console.WriteLine("State: {0}", connection.State);
- Console.WriteLine("ConnectionString: {0}",
- connection.ConnectionString);
- OracleCommand command = connection.CreateCommand();
- string sql = "SELECT * FROM myTableName";
- command.CommandText = sql;
- OracleDataReader reader = command.ExecuteReader();
- while (reader.Read())
- {
- string myField = (string)reader["MYFIELD"];
- Console.WriteLine(myField);
- }
- }
- }
- using System;
- using Oracle.DataAccess.Client;
- class OraTest
- {
- OracleConnection con;
- void Connect()
- {
- con = new OracleConnection();
- con.ConnectionString = "User Id=<username>;Password=<password>;Data Source=<datasource>";
- con.Open();
- Console.WriteLine("Connected to Oracle" + con.ServerVersion);
- }
- void Close()
- {
- con.Close();
- con.Dispose();
- }
- static void Main()
- {
- Example OraTest= new OraTest();
- OraTest.Connect();
- OraTest.Close();
- }
- }
Add Comment
Please, Sign In to add comment