本文整理汇总了C#中System.Data.Common.DbConnection.Open方法的典型用法代码示例。如果您正苦于以下问题:C# DbConnection.Open方法的具体用法?C# DbConnection.Open怎么用?C# DbConnection.Open使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbConnection
的用法示例。
在下文中一共展示了DbConnection.Open方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SqlFuConnection
public SqlFuConnection(DbConnection cnx,DbEngine engine)
{
cnx.MustNotBeNull();
_conex = cnx;
_provider = ProviderFactory.GetProvider(engine);
_conex.Open();
}
示例2: MachineParamsManager
public MachineParamsManager(Guid plowmachineId, Metadata.MetadataManager manager)
{
_plowMachineId = plowmachineId;
_manager = manager;
_connection = DBConnectionProvider.GetConnection();
_connection.Open();
}
示例3: DiscoverSpParameterSet
/// <summary>
/// Resolve at run time the appropriate set of DbParameters for a stored procedure
/// </summary>
/// <param name="transaction">A valid SqlTransaction object</param>
/// <param name="connection">A valid SqlConnection object</param>
/// <param name="storedProcedureName">The name of the stored procedure</param>
/// <param name="includeReturnValueParameter">Whether or not to include their return value parameter</param>
/// <returns>The parameter array discovered.</returns>
private static IList<SqlParameter> DiscoverSpParameterSet(DbTransaction transaction, DbConnection connection, string storedProcedureName, bool includeReturnValueParameter)
{
using (SqlCommand cmd = new SqlCommand(storedProcedureName, connection as SqlConnection))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
cmd.CommandType = CommandType.StoredProcedure;
if (transaction != null)
{
cmd.Transaction = transaction as SqlTransaction;
}
SqlCommandBuilder.DeriveParameters(cmd);
if (!includeReturnValueParameter)
{
cmd.Parameters.RemoveAt(0);
}
SqlParameter[] discoveredParameters = new SqlParameter[cmd.Parameters.Count];
cmd.Parameters.CopyTo(discoveredParameters, 0);
return discoveredParameters;
}
}
示例4: BeginTransaction
public void BeginTransaction()
{
_db = new SqlDatabase(_strConnection);
_dbConn = _db.CreateConnection();
_dbConn.Open();
_dbTrans = _dbConn.BeginTransaction();
}
示例5: Manager
public Manager(String fileName)
{
localization = new System.ComponentModel.ComponentResourceManager(typeof(WorkerTimeStrings));
this.fileName = fileName;
if (File.Exists(fileName)) {
this.sqlConnection = new SQLiteConnection("Data Source=" + fileName );
this.sqlCommand = this.sqlConnection.CreateCommand();
sqlConnection.Open();
} else {
this.sqlConnection = new SQLiteConnection("Data Source=" + fileName);
this.sqlCommand = this.sqlConnection.CreateCommand();
sqlConnection.Open();
ExecuteNonQuery("CREATE TABLE Tracks ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [ProjectID] INTEGER, [ActivityID] INTEGER, [Start] DATETIME, [End] DATETIME, [Duration] INTEGER)");
ExecuteNonQuery("CREATE TABLE Projects ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] TEXT)");
ExecuteNonQuery("CREATE TABLE Activity ([ID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] TEXT, [ProjectID] INTEGER)");
if (MessageBox.Show(localization.GetString("String10"), localization.GetString("String3"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes )
{
ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 1')");
ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 2')");
ExecuteNonQuery("INSERT INTO Projects (Name) VALUES ('" + localization.GetString("String12") + " 3')");
ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 1',1)");
ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 2',1)");
ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 3',1)");
ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 1',2)");
ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 2',2)");
ExecuteNonQuery("INSERT INTO Activity (Name,ProjectID) VALUES ('" + localization.GetString("String13") + " 3',2)");
}
}
Update1();
}
示例6: duiQuery
public void duiQuery(string QueryString)
{
using (_curConnection = _curDataObjFactory.CreateConnection())
{
try
{
_curConnection.ConnectionString = _connectionString;
_curConnection.Open();
using (DbCommand curCommand = _curDataObjFactory.CreateCommand())
{
curCommand.Connection = _curConnection;
curCommand.CommandText = QueryString;
curCommand.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
finally
{
_curConnection.Close();
}
}
}
示例7: DatabaseAccessTests
public DatabaseAccessTests()
{
_conn = SQLitePortability.CreateConnection();
_conn.Open();
_db = new DatabaseAccess(_conn, new SQLiteDetails());
}
示例8: GetCommandWrap
protected internal virtual IDbCommandWrap GetCommandWrap(IStatementSetting statement)
{
DbConnection connection;
var closeConnectionOnCommandDisposed = true;
if (this.IsInTransaction) {
if (this.transaction == null) {
lock (this.lockTransaction) {
if (this.transaction == null) {
connection = this.GetConnection(statement);
connection.Open();
if(this.DataService.Debug) {
LogService.WriteLog(this, LogLevel.DEBUG, "Connection open with transaction:" + connection.GetHashCode());
}
this.transaction = connection.BeginTransaction();
}
}
}
connection = this.Transaction.Connection;
closeConnectionOnCommandDisposed = false;
} else {
connection = this.GetConnection(statement);
connection.Open();
if(this.DataService.Debug) {
LogService.WriteLog(this, LogLevel.DEBUG, "Connection open without transaction:" + connection.GetHashCode());
}
}
var command = connection.CreateCommand();
command.Transaction = this.Transaction;
return new DbCommandWrap(command, closeConnectionOnCommandDisposed);
}
示例9: CreateDataBase
/// <summary>
/// 初次使用创建数据库
/// </summary>
public static void CreateDataBase()
{
try
{
bool isExist = File.Exists(DataPath);
if (!isExist)
{
SQLiteConnection.CreateFile(DataPath);
}
conn = new SQLiteConnection(ConnStr);
conn.Open();
comm = conn.CreateCommand();
if (!isExist)
{
String sql = "Create table ReceiveData(DeviceNum INTEGER , Temperature INTEGER , Humidity INTEGER , Tyrere INTEGER , MotorState INTEGER , ErrorNum INTEGER , CreateDate DateTime);";
comm.CommandText = sql;
comm.CommandType = CommandType.Text;
comm.ExecuteNonQuery();
}
}
catch (Exception e)
{
}
}
示例10: Setup
public void Setup()
{
var factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
var db = factory.CreateDefault();
connection = db.CreateConnection();
connection.Open();
}
示例11: Open
public void Open(string aConnectionString, ServerType serverType)
{
dbCache.ConnectionString = aConnectionString;
dbCache.ServerType = serverType;
switch (serverType)
{
case ServerType.Firebird:
connection = new FbConnection {ConnectionString = aConnectionString};
break;
case ServerType.MsSql:
connection = new SqlConnection { ConnectionString = aConnectionString };
break;
}
connection.Open();
if (serverType==ServerType.Firebird)
using (var transaction = connection.BeginTransaction())
{
DbData.GetFieldValue(connection, transaction,
"select rdb$set_context('USER_SESSION','RPL_SERVICE','1') from rdb$database;");
transaction.Commit();
}
var t = new Thread(LoadData);
t.Start();
}
示例12: select
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
conn.Open();
DataTable tb = new DataTable();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = DISCOUNTCURVESETTING_Table_DAO.SelectQuery_;
selectQuery = selectQuery.Replace("@[email protected]", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn);
DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn);
dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
if (!(rowCount == 0 || rowCount == 1))
{ throw new Exception(); }
foreach (DataRow item in dr)
{
this.CURRENCY_ = item[0].ToString();
this.CURVECODE_ = item[1].ToString();
this.PROVIDER_ = item[2].ToString();
}
}
示例13: PreStart
protected override void PreStart()
{
base.PreStart();
_connection = CreateDbConnection();
_connection.Open();
}
示例14: OpenConnection
public void OpenConnection(DbConnection dbc)
{
if (dbc.State == ConnectionState.Closed)
{
dbc.Open();
}
}
示例15: Connect_To_Database
public override void Connect_To_Database(StorageConfig config)
{
myConfig = config as SQLiteConfig;
if (myConfig == null)
throw new Exception("Database Config is NULL");
if (!FileNameLockObjects.ContainsKey(myConfig.DatabaseFile))
FileNameLockObjects.Add(myConfig.DatabaseFile,new object());
try
{
myDBConn = new SQLiteConnection(ConnectionString);
myDBConn.Open();
if (myDBConn.State != System.Data.ConnectionState.Open)
throw new Exception("Unable to Open Database. Storage:" + config.Name);
}
catch (SQLiteException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}