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