/// <summary>
/// Get the ban list for the specified account
/// </summary>
/// <param name="dsTable">The ban list.</param>
public void GetBanListByAccDir(DamDataSet.BanListDataTable dsTable, string accDir, bool onlyExistent)
{
dsTable.Clear();
SQLiteDataAdapter adpt = new SQLiteDataAdapter("SELECT * FROM BanList WHERE AccDir ='" + accDir + "'", GetConnection());
adpt.Fill(dsTable);
}
/// <summary>
/// Get all existent ban list records.
/// </summary>
/// <param name="dsTable">The ban list.</param>
public void GetBanList(DamDataSet.BanListDataTable dsTable)
{
string query = "SELECT * FROM BanList";
dsTable.Clear();
SQLiteDataAdapter adpt = new SQLiteDataAdapter(query, GetConnection());
adpt.Fill(dsTable);
}
