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]);
}
}
}