public int process(SqlBoxQuery query, ArrayList results) { int count = -1; if (!query.IsEmpty()) { this.m_lastQuery = query.ToString(); if (this.DbConnection == null) { return count; } try { OleDbCommand command = this.DbConnection.CreateCommand(); command.CommandText = query.ToString(); OleDbDataReader resultSet = command.ExecuteReader(); this.CollectResultsInList(results, resultSet); count = results.Count; resultSet.Close(); } catch (Exception exception) { this.error.message = "An error occurred while processing a query."; this.error.info = exception.ToString(); } } return count; }
public int process(SqlBoxQuery query) { int num = -1; if (!query.IsEmpty()) { this.m_lastQuery = query.ToString(); if ((this.DbConnection == null) || (this.DbConnection.State != System.Data.ConnectionState.Open)) { return num; } try { OleDbCommand command = this.DbConnection.CreateCommand(); command.CommandText = query.ToString(); num = command.ExecuteNonQuery(); } catch (Exception exception) { this.error.message = "An error occurred while processing a query."; this.error.info = exception.ToString(); } } return num; }