C# OracleConnection.Open方法代码示例

 public List<Maintenance> GetControl()
 {
     List<Maintenance> list = new List<Maintenance>();
     String command = "SELECT dzid,sbdm,bddm,ywmz,zwmz,dzlb,jtms FROM CW_YBdz_ygyb where ztbz=1 order by dzid desc";
     using (OracleConnection con = new OracleConnection(connectionString))
     {
         con.Open();
         OracleCommand queryCommand = new OracleCommand(command, con);
         //OracleCacheDependency dependency = new OracleCacheDependency(queryCommand);
         var reader = queryCommand.ExecuteReader();
         while (reader.Read())
         {
             Maintenance maintenance = new Maintenance();
             maintenance.ControlID = reader.GetInt32(0);
             maintenance.SocialSecurityCode = reader.GetValue(1).ToString();
             maintenance.LocalCode = reader.GetValue(2).ToString();
             maintenance.EnglishName = reader.GetValue(3).ToString();
             maintenance.ChineseName = reader.GetValue(4).ToString();
             maintenance.Type = reader.GetValue(5).ToString();
             maintenance.Description = reader.GetValue(6).ToString();
             list.Add(maintenance);
         }
     }
     return list;
 }

            /// <summary>
            /// Selects and retrieves values from the database 
            /// </summary>
            /// <param name="query">The selection statement</param>
            /// <returns>A DataTable with the retrieved values></returns>
            public static DataTable RetrieveQuery(string query)
            {
                if (Regex.IsMatch(query, @"-{2,}"))
                {
                    throw new SQLInjectionException();
                }

                using (OracleConnection c = new OracleConnection(@connectionstring))
                {
                    try
                    {
                        c.Open();
                        OracleCommand cmd = new OracleCommand(@query);
                        cmd.Connection = c;
                        try
                        {
                            OracleDataReader r = cmd.ExecuteReader();
                            DataTable result = new DataTable();
                            result.Load(r);
                            c.Close();
                            return result;
                        }
                        catch (OracleException e)
                        {
                            Console.Write(e.Message);
                            throw;
                        }
                    }
                    catch (OracleException e)
                    {
                        Console.Write(e.Message);
                        return new DataTable();
                    }
                }
            }

        /**
            Permite eliminar un cliente
        */
        public string deleteCustomer(string id)
        {
            string deleteCustomer = "DELETE FROM CUSTOMERS.CUSTOMER WHERE Id = :Id";

            OracleTransaction transaction;
            using (OracleConnection connection = new OracleConnection())
            {
                connection.ConnectionString = ConfigurationManager.ConnectionStrings["customerDb"].ConnectionString;

                try
                {
                    connection.Open();
                    transaction = connection.BeginTransaction();
                    deleteCustomerAddress(id, connection, transaction);

                    using (OracleCommand command = new OracleCommand(deleteCustomer, connection))
                    {
                        command.Parameters.Add(new OracleParameter("Id", id));

                        command.ExecuteNonQuery();
                        transaction.Commit();
                    }
                }
                catch (Exception e)
                {
                    throw new PlatformException(e.Message);
                }
            }

            return "OK";
        }

 public string[] GetSearchItems(string prefix)
 {
     List<string> items = new List<string>();
     using (OracleConnection conn = new OracleConnection())
     {
         conn.ConnectionString = ConfigurationManager
                 .ConnectionStrings["Bazi"].ConnectionString;
         using (OracleCommand cmd = new OracleCommand())
         {
             cmd.CommandText = "select ime,igraid from Igra where upper(ime) like upper(:SearchText)||'%'";
             cmd.Parameters.Add(new OracleParameter("SearchText", prefix));
             cmd.Connection = conn;
             conn.Open();
             using (OracleDataReader sdr = cmd.ExecuteReader())
             {
                 while (sdr.Read())
                 {
                     items.Add(string.Format("{0}`{1} Game", sdr.GetString(0), sdr.GetInt64(1)));
                 }
             }
             cmd.CommandText = "select IMEMODEL,HARDID from HARDVERPROIZVOD where upper(IMEMODEL) like upper(:SearchText)||'%'";
             using (OracleDataReader rdr = cmd.ExecuteReader())
             {
                 while (rdr.Read())
                 {
                     items.Add(string.Format("{0}`{1} Hardware", rdr.GetString(0), rdr.GetInt64(1)));
                 }
             }
             conn.Close();
         }
         return items.ToArray();
     }
 }

        // GET: Album
        //  [HttpPost]
        public List<AlbumModels> Album()
        {
            OracleConnection conn = new OracleConnection(oradb);

                conn.Open();
                string selectStr =   /* "insert into album(albumID,albumname,username) values('111','testalbum','KING')";*/
                                       "select * "
                                       + "from album ";
                    // " +(Session["username"] as string)+"

                OracleCommand cmd = new OracleCommand(selectStr, conn);
                OracleDataReader dr = cmd.ExecuteReader();
                var Models = new List<AlbumModels>();
                while (dr.Read())
                {

                    AlbumModels model = new AlbumModels();
                    model.AlbumName = dr["albumname"].ToString();
                    model.AlbumId = dr["albumid"].ToString();
                    //model.Username = Session["username"] as string ;
                    string selectStr1 = "select * from photo where albumid = " + model.AlbumId;
                    OracleCommand cmd1 = new OracleCommand(selectStr1, conn);
                    OracleDataReader dr1 = cmd1.ExecuteReader();
                    dr1.Read();
                    model.Firstphoto = dr1["photoaddress"].ToString();
                    Models.Add(model);
                    //Session.Add("currentAlbumName", albumName);
                    //Session.Add("currentAlbumId", albumId);         //点击时保存到session
                }
                dr.Close();
                int insertedLines = cmd.ExecuteNonQuery();
                conn.Close();
                conn.Dispose();
                return Models;
        }

        public List<PaisDTO> getPais() 
        {
            List<PaisDTO> lstPais = new List<PaisDTO>();
            Parametros p = new Parametros();
            PaisDTO itemPais;

            using (OracleConnection con = new OracleConnection(p.oracleConnString().ToString()))
            {
                con.Open();

                OracleCommand cmd = con.CreateCommand();                
                cmd.CommandText = "select IDPAIS, NOMBREPAIS from pais";

                using (OracleDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        itemPais = new PaisDTO();
                        itemPais.idPais = reader.GetInt32(0);
                        itemPais.nombrePais = reader.GetString(1);
                        lstPais.Add(itemPais);
                    }
                }

                con.Close();
                con.Dispose();
            }

            return lstPais;
        }

        private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            while (!backgroundWorker1.CancellationPending)
            {
                try
                {
                    using (var conn = new OracleConnection(textBox1.Text))
                    {
                        conn.Open();
                        using (var cmd = conn.CreateCommand())
                        {
                            cmd.CommandText = "SELECT 'OK' FROM DUAL";
                            var result = (string) cmd.ExecuteScalar();
                            AppendText(string.Format("{0}: Sql executed OK", DateTime.Now));
                        }
                    }
                }
                catch (Exception ex)
                {
                    //MessageBox.Show(ex.ToString());
                    AppendText(string.Format("{0}: Error:{1}", DateTime.Now, ex.Message));
                }

                for (var i = 0; i < 100; i++)
                {
                    Thread.Sleep(30);
                    if (backgroundWorker1.CancellationPending) return; 
                }
            }
        }

        public static DBInternalMessages DBNonQuery(string conStr, string sqlstr)
        {
            OracleConnection _dbconnection = new OracleConnection(conStr);

            _dbconnection.Open();

            try
            {
                if (_dbconnection.State == ConnectionState.Open)
                {
                    OracleCommand _command = new OracleCommand(sqlstr, _dbconnection);
                    int r = _command.ExecuteNonQuery();
                    _dbconnection.Close();
                    if (r > 0)
                    {
                       return DBInternalMessages.DB_NonQuerySuccess;// "Success";
                    }
                    else
                    {
                        return  DBInternalMessages.DB_NonQueryFailed;
                    }
                }
                else
                {
                    return DBInternalMessages.DB_NOT_OPEN; //db not open
                }

            }
            catch (Exception ex)
            {
                _dbconnection.Close();
                LoggingHelper.WriteLog("AkkaTestServer", "DBNonQuery Ex:" + ex.Message);
                return DBInternalMessages.DB_Exception; //ex
            }
        }

 public static string addbindCompanyHardware(string companyId, string hardwareId)
 {
     OracleConnection oracleConnection = new OracleConnection(ConfigurationManager.ConnectionStrings["Bazi"].ConnectionString);
     OracleCommand cmd = new OracleCommand();
     string query = "INSERT INTO IzdavaHardver(koid,hardid) values (:koid,:hardid)";
     cmd.Connection = oracleConnection;
     cmd.CommandText = query;
     cmd.Parameters.Add(new OracleParameter("koid", companyId));
     cmd.Parameters.Add(new OracleParameter("hardid", hardwareId));
     try
     {
         oracleConnection.Open();
         int effect = cmd.ExecuteNonQuery();
         if (effect > 0)
         {
             return "Врската е успешно додадена";
         }
     }
     catch (Exception e)
     {
         return e.Message;
     }
     finally
     {
         oracleConnection.Close();
     }
     return "проблем со базата";
 }

        public Aluno_Cadastrar(int mat_instrut)
        {
            InitializeComponent();
            matricula_instrutor = mat_instrut;

            try
            {
                OracleConnection conn = new OracleConnection(oradb);
                conn.Open();

                OracleCommand oda = new OracleCommand("SELECT COUNT(matricula) FROM pessoa", conn);
                OracleDataReader reader = oda.ExecuteReader();
                if (reader.HasRows)
                {
                    reader.Read();
                    int tot_matr = reader.GetInt32(0) + 1;
                    tbx_matricula.Text = Convert.ToString(tot_matr);
                }
                conn.Close();
            }
            catch (Exception ex) // detecta todos os erros
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }

        public DataTable throwSelect(string sql)
        {
            DataTable dt = new DataTable();

            string ConnectionString = "";
            ConnectionString = "DATA SOURCE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.70)(PORT = 1521)))";
            ConnectionString += "(CONNECT_DATA = (SERVICE_NAME = UBIZDB)));";
            ConnectionString += "USER ID=RCS;PASSWORD=RCS";

            OracleConnection conn = new OracleConnection(ConnectionString);

            conn.Open();

            OracleCommand oracmd = new OracleCommand();
            oracmd.Connection = conn;
            oracmd.CommandType = CommandType.Text;

            oracmd.CommandText = sql;

            OracleDataAdapter adapter = new OracleDataAdapter();

            adapter.SelectCommand = oracmd;

            //adapter.Fill(ds);
            adapter.Fill(dt);

            return dt;
        }

        public IList<VeiculoDTO> RetornarListaDeVeiculos() {


            string _conectionString = ConfigurationManager.ConnectionStrings["BDJBS"].ConnectionString;
            IList<VeiculoDTO> veiculos = new List<VeiculoDTO>();



            using (OracleConnection conexaoOracle = new OracleConnection(_conectionString)) {

                conexaoOracle.Open();

                OracleCommand comandoOracle = new OracleCommand();
                comandoOracle.Connection = conexaoOracle;
                comandoOracle.CommandType = System.Data.CommandType.StoredProcedure;
                comandoOracle.CommandText = "SP_RETORNARVEICULOS";
                comandoOracle.Parameters.Add("VEICULOS",OracleDbType.RefCursor,System.Data.ParameterDirection.Output);

                OracleDataReader leitor = comandoOracle.ExecuteReader();
                while (leitor.Read())
                {
                    veiculos.Add(new VeiculoDTO {Placa = leitor.GetString(0), Categoria = leitor.GetInt16(1) });
                }
            }

            return veiculos;

        }

        private long AddSeason(string seasonName, float seasonPrice)
        {
            long seasonId = 0;
            using (OracleConnection objConn = new OracleConnection(Global.ConnectionString))
            {
                var command = new OracleCommand("TICKETS_API.insertSeason", objConn);
                command.Parameters.Add("p_Return", OracleDbType.Int64, ParameterDirection.ReturnValue);
                command.Parameters.Add("p_SeasonName", OracleDbType.Varchar2, seasonName, ParameterDirection.Input);
                command.Parameters.Add("p_SeasonPrice", OracleDbType.Decimal, seasonPrice, ParameterDirection.Input);
                command.CommandType = CommandType.StoredProcedure;

                try
                {
                    objConn.Open();
                    command.ExecuteNonQuery();
                    seasonId = long.Parse(command.Parameters["p_Return"].Value.ToString());
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }

            return seasonId;
        }

 public OracleManagedDriverTransformationProvider(Dialect dialect, string connectionString, string defaultSchema)
     : base(dialect, connectionString, defaultSchema)
 {
     _connection = new OracleConnection();
     _connection.ConnectionString = _connectionString;
     _connection.Open();
 }

        private void button2_Click(object sender, EventArgs e)
        {
            // LotNo.Clear();
               // Quantity.Clear();
               // Price.Clear();

            string _connstring = "Data Source=ORCL;User Id = scott;Password=tiger;";
             //           decimal _totalRecords;
            String name;
            try
            {
            OracleConnection _connObj = new OracleConnection(_connstring);
            _connObj.Open();
            OracleCommand _cmdObj = _connObj.CreateCommand();
            //            _cmdObj.CommandText = "SELECT ename from employees where empid = 101";
            _cmdObj.CommandText = "SELECT ename from emp";
             //           _totalRecords = (decimal)_cmdObj.ExecuteScalar();
            name = (String)_cmdObj.ExecuteScalar();
            MessageBox.Show("Total records:" + name);
            textBox1.AppendText("Name: " + name);
            _connObj.Close();
            _connObj.Dispose();
            _connObj = null;
            }
            catch (Exception ex)
            {
            MessageBox.Show(ex.ToString());
            }
        }