可以利用ole_db,代码如下:
string strCon=“Provider=MSDAORA;DSN=oracle;UserID=system;Password=manager”;
OleDbConnection myconn=new OleDbConnection(strCon);
myconn.Open();
string strcom=“select × from customer”;
OleDbDataAdapter mycommand=new OleDbDataAdapter(strcom,myconn);
string strCon=“Provider=MSDAORA;DSN=oracle;UserID=system;Password=manager”;
OleDbConnection myconn=new OleDbConnection(strCon);
myconn.Open();
string strcom=“select × from customer”;
OleDbDataAdapter mycommand=new OleDbDataAdapter(strcom,myconn);
string strConn="Data Source=ddl;user id=system;password=manager ; OracleConnection myConnection = new OracleConnection(strConn);
OracleCommand myCommand = new OracleCommand(strtmp, myConnection);
myCommand.Connection .Open() ;
string strcom ="select * from table "
myCommand.ExecuteNonQuery();
myCommand.Dispose ();
myCommand.Connection.Close ();