//???:??????????:
//???->???????->.NET->System.Data.OracleClient.dll
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OracleClient;
using System.Data;
namespace LinkOrcale
{
class Program
{
static void Main(string[] args)
{
string ConnectionString="Data Source=orcl;user=scott;password=Admin518;";//д?????
OracleConnection conn=new OracleConnection(ConnectionString);//?????????????
try
{
conn.Open();
OracleCommand cmd=conn.CreateCommand();
cmd.CommandText="select * from emp";//?????дsql???
OracleDataReader odr=cmd.ExecuteReader();//???????OracleDateReader????
while(odr.Read())//???????????odr.Read()?????false?????????????????β????
{
Console.WriteLine(odr.GetOracleNumber(0) + " " + odr.GetOracleString(1).ToString() + " " + odr.GetOracleString(2).ToString() + " " + odr.GetOracleNumber(3) + " "+odr.GetOracleDateTime(4));
//??????1??????????????????
}
odr.Close();
}
catch(Exception e)
{
Console.WriteLine("??????"+e.GetBaseException());
}
finally
{
conn.Close(); //???????
}
}
}
}