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);
}
