René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Oracle, ADO and .NET

using System;
using System.Data;
using System.Data.OracleClient;

class ADO_basic {
  [STAThread]
  static void Main(string[] args) {

    OracleConnection conn = new OracleConnection("Data Source=laptopdb;User ID=aaa;password=bbb");
    conn.Open();

    OracleDataAdapter adapt = new OracleDataAdapter("select * from test_table where a between 10 and 50", conn);

    DataSet dataSet = new DataSet();
    adapt.Fill(dataSet,"MeinResultat");

    conn.Close();

    DataTable tab = dataSet.Tables["MeinResultat"];

    foreach (DataRow row in tab.Rows) {
      Console.WriteLine("{0} {1}",row[0],row[1]);
    }
  }
}

The same thing, but connecting sql server.