/// <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));
}