谁有用C#写链接orcal8i的源程序?

Question

OracleConnection和连接SqlServer差不多

Answer 1

安装oracle驱动就ok了， 好象ODBC里面本来就有oracle client。
楼上的也对，OLEDB就行了

Answer 2

小例子：
compile 时。csc   /r:System.Data.OracleClient.dll /out:\db.exe db.cs   using System.Data.OracleClient;      public class DBTOOL
      {
         string m_DataSource  ;
       string m_Password    ;
       string m_UserID      ;    private System.Data.OracleClient.OracleConnection  m_Connection;
    private System.Data.OracleClient.OracleTransaction m_Trans;    private const string m_ConnectionStringFormat = @"Data Source={0};Integrated Security=no;Password={1};User ID={2}";
    private string m_ConnectionString ;         public DBTOOL()
         {
            m_Connection = new OracleConnection();
         }         public OracleConnection CONNECTION
         {
            get
            {
               return m_Connection;
            }
            set
            {
               m_Connection =value;
            }
         }        public string DATASOURCE
         {
            get
            {
               return m_DataSource;
            }
            set
            {
               m_DataSource =value;
            }
         }         public string PASSWORD
         {
            get
            {
               return m_Password;
            }
            set
            {
               m_Password =value;
            }
         }         public string USERID
         {
            get
            {
               return m_UserID;
            }
            set
            {
               m_UserID =value;
            }
         }         public bool DbConn()
         {
            try
            {
               m_ConnectionString = string.Format( m_ConnectionStringFormat,DATASOURCE,PASSWORD,USERID);    m_Connection.ConnectionString = m_ConnectionString;               Console.WriteLine( "ConnectionString {0}",m_Connection.ConnectionString);       if ( m_Connection.State != System.Data.ConnectionState.Open )
       m_Connection.Open();               Console.WriteLine( "DBConn  succ");
               return true ;
            }
            catch(Exception e)
            {
               Console.WriteLine( "DBConn  execption [{0}] ",e.ToString() );
               return false ;
            }
         }         public bool DbClose()
         {
            if( m_Connection.State == System.Data.ConnectionState.Open )
            {
               try
               {
                  m_Connection.Close();
                  Console.WriteLine( "DBClose  succ");
                  return true;
               }
               catch(Exception e)
               {
                  Console.WriteLine( "DBClose  execption [{0}] ",e.ToString() );
                  return false ;
               }
            }            Console.WriteLine( "DBClose  succ");
            return true;
         }         public bool Excute(OracleConnection i_Connection ,string i_query )
         {
            OracleCommand myCommand = new OracleCommand();
            string mySelectQueryGZ =  i_query;    myCommand.Connection = i_Connection;
            m_Trans = i_Connection.BeginTransaction();
            myCommand.CommandText = mySelectQueryGZ;
       myCommand.Transaction = m_Trans;            //Console.WriteLine( " myCommand.CommandText [{0}]",myCommand.CommandText);            myCommand.ExecuteNonQuery();            m_Trans.Commit();            return true;         }         public OracleDataReader Select(OracleConnection i_Connection ,string i_query )
         {
            string mySelectQueryGZ =  i_query;            OracleCommand myCommand = new OracleCommand();
            myCommand.CommandText = mySelectQueryGZ;
            myCommand.Connection = i_Connection;            OracleDataReader myReader ;
       myReader = myCommand.ExecuteReader();
            return myReader ;
         }
      }