本文整理汇总了C#中OracleConnection.Open方法的典型用法代码示例。如果您正苦于以下问题:C# OracleConnection.Open方法的具体用法?C# OracleConnection.Open怎么用?C# OracleConnection.Open使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OracleConnection
的用法示例。
在下文中一共展示了OracleConnection.Open方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetControl
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;
}
示例2: RetrieveQuery
/// <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();
}
}
}
示例3: deleteCustomer
/**
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";
}
示例4: GetSearchItems
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();
}
}
示例5: Album
// 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;
}
示例6: getPais
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;
}
示例7: backgroundWorker1_DoWork
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;
}
}
}
示例8: DBNonQuery
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
}
}
示例9: addbindCompanyHardware
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 "проблем со базата";
}
示例10: Aluno_Cadastrar
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());
}
}
示例11: throwSelect
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;
}
示例12: RetornarListaDeVeiculos
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;
}
示例13: AddSeason
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;
}
示例14: OracleManagedDriverTransformationProvider
public OracleManagedDriverTransformationProvider(Dialect dialect, string connectionString, string defaultSchema)
: base(dialect, connectionString, defaultSchema)
{
_connection = new OracleConnection();
_connection.ConnectionString = _connectionString;
_connection.Open();
}
示例15: button2_Click
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());
}
}