private void cmbCelula_SelectedIndexChanged(object sender, EventArgs e) { cmbRuta.Items.Clear(); List <RutaCombo> listaRutas = ConsultaRutas(((GrupoCombo)cmbCelula.SelectedItem).IdGrupo); RutaCombo r = new RutaCombo(); r.IdRuta = 0; r.Descripcion = "SELECCIONE"; cmbRuta.Items.Add(r); foreach (RutaCombo rc in listaRutas) { cmbRuta.Items.Add(rc); } cmbRuta.ValueMember = "IdRuta"; cmbRuta.DisplayMember = "Descripcion"; if (cmbRuta.Items.Count > 0) { cmbRuta.SelectedIndex = 0; } }
public List <RutaCombo> ConsultaRutas(int Grupo) { List <RutaCombo> lista = new List <RutaCombo>(); SqlConnection connection = null; try { connection = new SqlConnection(conexionGPS); connection.Open(); SqlCommand command = new SqlCommand("spLOGConsultaRutas", connection); command.Parameters.Add("@IdGrupo", SqlDbType.Int).Value = Grupo; command.CommandType = CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { RutaCombo c = new RutaCombo(); c.IdRuta = int.Parse(reader["IdRuta"].ToString()); c.Descripcion = reader["Descripcion"].ToString(); lista.Add(c); } } catch (Exception ex) { lista = null; throw ex; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return(lista); }