public void ExecuteNonQuery(List <string> commandTexts) { using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString)) { using (OleDbTransaction transaction = pool.Connection.BeginTransaction()) { using (OleDbCommand command = new OleDbCommand()) { try { command.Connection = pool.Connection; command.Transaction = transaction; foreach (string str in commandTexts) { command.CommandText = str; command.ExecuteNonQuery(); } transaction.Commit(); } catch { transaction.Rollback(); throw; } } } } }
public OleDbDataReader ExecuteReader(string commandText, OleDbParameter[] pt) { AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString); using (OleDbCommand command = new OleDbCommand(commandText, pool.Connection)) { if (pt != null) { command.Parameters.AddRange(pt); } return(command.ExecuteReader(CommandBehavior.CloseConnection)); } }
public void ExecuteNonQuery(string commandText, OleDbParameter[] pt) { using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString)) { using (OleDbCommand command = new OleDbCommand(commandText, pool.Connection)) { if (pt != null) { command.Parameters.AddRange(pt); } command.ExecuteNonQuery(); } } }
public void Dispose() { if (AccessPoolManager.pools.ContainsKey(this.id) && (AccessPoolManager.pools[this.id] != null)) { AccessPoolManager.AccessPool pool = AccessPoolManager.pools[this.id]; pool.IsUsing = false; TimeSpan span = (TimeSpan)(DateTime.Now - pool.StartTime); if (span.TotalSeconds > AccessPoolManager.timeOut) { pool.Connection.Close(); AccessPoolManager.pools.Remove(this.id); } } }
public DataTable ExecuteDataTable(string commandText, OleDbParameter[] pt) { DataTable dataTable = new DataTable(); using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString)) { using (OleDbDataAdapter adapter = new OleDbDataAdapter(commandText, pool.Connection)) { if (pt != null) { adapter.SelectCommand.Parameters.AddRange(pt); } adapter.Fill(dataTable); } } return(dataTable); }
public object ExecuteScalar(string commandText, OleDbParameter[] pt) { object obj2; using (AccessPoolManager.AccessPool pool = AccessPoolManager.Instance(this.connectionString)) { using (OleDbCommand command = new OleDbCommand(commandText, pool.Connection)) { if (pt != null) { command.Parameters.AddRange(pt); } obj2 = command.ExecuteScalar(); } } return(obj2); }