ODBC 连接 oracle 数据库的方法:
static void Main(string[] args)
{
OdbcConnection conn = null; // 连接对象;
OdbcCommand comm = null;// 命令对象;
OdbcDataReader dr = null;// 数据读取对象;
string pid, cid, pname;
try
{
// 连接字符串;
string connstr = "DSN=Chweiorc;UID=scott;PWD=Chwei926a";
conn = new OdbcConnection(connstr);
//向oracle数据库发送SQL语句
comm = new OdbcCommand("select * from student",conn);
conn.Open();
//获得SQL语句返回的结果;
dr = comm.ExecuteReader();
Console.WriteLine("姓名\t学号\t性别");
Console.WriteLine("--------------------------------------------------------");
while (dr.Read())
{
//逐条处理数据记录
pid = dr.GetString(0).Trim();
cid = dr.GetString(1).Trim();
pname = dr.GetString(2).Trim();
Console.WriteLine(pid + "\t" + cid + "\t" + pname );
}
conn.Close();
}
catch (Exception err)
{
Console.WriteLine(err.ToString());
}
Console.Read();
}