/// <summary> /// Returns an ArrayList of the rows of the results of the /// given query. /// </summary> /// <param name="query">The SQL to execute</param> /// <returns>ArrayList of hashtables of row data</returns> public ArrayList GetAllHash(string query) { SQLiteResultSet results = this.Execute(query); ArrayList rows = new ArrayList(); // Loop through rows calling GetRowHash() while (results.IsMoreData) { rows.Add(results.GetRowHash()); } return(rows); }
/// <summary> /// Returns a hashtable row of resultset with given row index /// </summary> /// <param name="query">The query to perform</param> /// <param name="row">The row index to return</param> /// <returns>Hashtable of row data</returns> public Hashtable GetRowHash(string query, int row) { SQLiteResultSet resultSet = this.Execute(query); return(resultSet.GetRowHash(row)); }