public partial class EnterResults : Form { SqlConnection dbConnection; SqlCommand dbCommand; DataSet dsResults; SqlDataAdapter dbAdapter; public EnterResults() { InitializeComponent(); } private void EnterResults_Load(object sender, EventArgs e) { dbConnection = new SqlConnection("Initial Catalog = Rugby_World_Cup; Data Source = localhost; Integrated Security= True"); dbCommand = new SqlCommand("SELECT * FROM Game", dbConnection); dbAdapter = new SqlDataAdapter(dbCommand); dsResults = new DataSet(); dbAdapter.Fill(dsResults, "Result"); cboGameID.DataSource = dsResults.Tables["Result"]; cboGameID.DisplayMember = "GameId"; cboGameID.SelectedIndex = -1; } private void btnEnter_Click(object sender, EventArgs e) { if (dbConnection.State == ConnectionState.Closed) { dbConnection.Open(); } dbCommand = new SqlCommand("EnterGame", dbConnection); dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@GameID", cboGameID.SelectedValue.ToString()); dbCommand.Parameters.AddWithValue("@CountryID", cboCountryID.SelectedValue.ToString()); dbCommand.Parameters.AddWithValue("@Tries", txtTries.Text); dbCommand.Parameters.AddWithValue("@Penalty", txtPenalties.Text); dbCommand.Parameters.AddWithValue("@DropG", txtDropGoals.Text); dbCommand.Parameters.AddWithValue("@Points", txtPoints.Text); if (dbCommand.ExecuteNonQuery() > 0) { MessageBox.Show("Results where Entered"); } cboGameID.SelectedIndex = -1; cboCountryID.SelectedIndex = -1; txtDropGoals.Clear(); txtPenalties.Clear(); txtPoints.Clear(); txtTries.Clear(); cboGameID.Focus(); } private void cboGameID_SelectedIndexChanged(object sender, EventArgs e) { dbCommand = new SqlCommand("Select * from game", dbConnection); dbCommand.Parameters.AddWithValue("@ID",cboGameID.SelectedValue.ToString()); dbAdapter = new SqlDataAdapter(dbCommand); dsResults = new DataSet(); dbAdapter.Fill(dsResults, "enter"); cboCountryID.DataSource = dsResults.Tables["enter"]; cboCountryID.DisplayMember = "CountryId"; cboCountryID.SelectedIndex = -1; } } }
var GamenName = from game in dbContext.Games where game.CountryId == cboCountryID.SelectedIndex.ToString() select game.name;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)