using System;
using System.Data.OracleClient;
public class OracleConn
{
static void Main(string [] args)
{
OracleDataReader Dr;
string strSQL="select * from Table";
string ConnectionString="Data Source=数据库名;User ID=用户名;Password=密码";
OracleConnection connection = new OracleConnection(ConnectionString);
OracleCommand cmd = new OracleCommand(strSQL, connection);
try
{
connection.Open();
Dr = cmd.ExecuteReader();
while (Dr.Read())
{
Console.Write(Dr["字段"].ToString() + "/r/n");
}
cmd.Dispose();
connection.Close();
}
catch(OracleException Ex)
{
Console.Write(Ex.ToString());
}
}
}
C# 连接ORACLE
最新推荐文章于 2024-10-11 12:00:25 发布