protected void FillCityCombo(string country) { if (string.IsNullOrEmpty(country)) { return; } AccessDataSourceCities.SelectParameters[0].DefaultValue = country; CmbCity.DataBind(); }
protected void CmbCity_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e) { if (string.IsNullOrEmpty(e.Parameter)) { return; } var parameters = e.Parameter.Split('|'); SqlDataSource3.SelectParameters["Country"].DefaultValue = parameters[0]; SqlDataSource3.SelectParameters["Salesperson"].DefaultValue = parameters[1]; CmbCity.DataBind(); }
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(); }