private void CmbFill()
{
CmbAirline.ResetText();
CmbCity.ResetText();
CmbGate.ResetText();
CmbRunway.ResetText();
CmbType.ResetText();
con.Open();
string query = "SELECT Airline FROM Airlines";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CmbAirline.Items.Add(reader.GetString(0));
}
con.Close();
con.Open();
string query1 = "SELECT City FROM Cities";
SqlCommand cmd1 = new SqlCommand(query1, con);
SqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
CmbCity.Items.Add(reader1.GetString(0));
}
con.Close();
con.Open();
string query2 = "SELECT Gate FROM Gates";
SqlCommand cmd2 = new SqlCommand(query2, con);
SqlDataReader reader2 = cmd2.ExecuteReader();
while (reader2.Read())
{
CmbGate.Items.Add(reader2.GetString(0));
}
con.Close();
con.Open();
string query3 = "SELECT Runway FROM Runways";
SqlCommand cmd3 = new SqlCommand(query3, con);
SqlDataReader reader3 = cmd3.ExecuteReader();
while (reader3.Read())
{
CmbRunway.Items.Add(reader3.GetString(0));
}
con.Close();
}
