public NhlStatsSet.teamsDataTable GetDivisionTeams(string division) { NhlStatsSet.teamsDataTable table = new NhlStatsSet.teamsDataTable(); SQLiteCommand command = new SQLiteCommand(); command.Connection = connection; command.CommandText = String.Format("SELECT * FROM (SELECT TeamName, TeamID, Division FROM teams WHERE " + "(Division = '{0}') GROUP BY TeamName) GROUP BY TeamID", division); SQLiteDataAdapter adapter = new SQLiteDataAdapter(command); adapter.Fill(table); System.Diagnostics.Debug.Assert(table.Rows.Count == 5); return table; }
public NhlStatsSet.teamsDataTable GetExistantTeam(string team) { NhlStatsSet.teamsDataTable table = new NhlStatsSet.teamsDataTable(); SQLiteCommand command = new SQLiteCommand(); command.Connection = connection; command.CommandText = String.Format( "SELECT TeamID, TeamName, TeamCity, Conference, Division " + "FROM teams " + "WHERE (TeamName LIKE '%{0}%') OR " + "(TeamCity LIKE '%{0}%') AND (NOT (Conference = 'Nonexistent'))", team); SQLiteDataAdapter adapter = new SQLiteDataAdapter(command); adapter.Fill(table); return table; }