SqlConnection dbConnection; SqlCommand dbCommand; DataSet ds; SqlDataAdapter dbAdapter; SqlDataReader dbread; public GamesforCountry(SqlConnection dbConnection) { this.dbConnection = dbConnection; InitializeComponent(); } private void GamesforCountry_Load(object sender, EventArgs e) { dbCommand = new SqlCommand("SELECT * FROM Country",dbConnection); dbAdapter = new SqlDataAdapter(dbCommand); ds = new DataSet(); dbAdapter.Fill(ds, "GamesFor"); cboCountryName.DataSource = ds.Tables["GamesFor"]; cboCountryName.DisplayMember = "CountryName"; cboCountryName.ValueMember = "CountryId"; } private void cboCountryName_SelectedIndexChanged(object sender, EventArgs e) { if (dbConnection.State == ConnectionState.Closed) { dbConnection.Open(); } dbCommand = new SqlCommand("SELECT Game.GameId,CountryName,Location,Date,Time FROM Game,Results,Country WHERE Results.CountryId = Country.CountryId AND Game.GameId = Results.GameId AND Country.CountryName ='" + cboCountryName.SelectedValue + "'", dbConnection); dbAdapter = new SqlDataAdapter(dbCommand); ds = new DataSet(); dbAdapter.Fill(ds, "view"); dgvGamesforCountry.DataSource = ds.Tables["view"];
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)