public NHLDatabaseOperator() { nhlStatsDatabase = new NhlStatsSet(); String dbPath = "nhlstatsdb"; connection = new SQLiteConnection("Data Source=" + dbPath); connection.Open(); playerStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.playerstatsTableAdapter(); goalieStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.goaliestatsTableAdapter(); teamStatsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.teamstatsTableAdapter(); seasonsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.seasonsTableAdapter(); scheduleAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.scheduleTableAdapter(); teamsAdapter = new NHLScoreBot.NhlStatsSetTableAdapters.teamsTableAdapter(); playerStatsAdapter.Connection = connection; goalieStatsAdapter.Connection = connection; teamStatsAdapter.Connection = connection; scheduleAdapter.Connection = connection; teamsAdapter.Connection = connection; }
public NhlStatsSet.playerstatsDataTable QueryPlayerStats(String query) { NhlStatsSet result = new NhlStatsSet(); DataAdapter adapter = new SQLiteDataAdapter(query, connection); adapter.Fill(result); return result.playerstats; }