private void cmbEst_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Manejadora mane = new Manejadora();
SqlConnection conn = mane.ConexionDBQuery();
cmbPatente.Items.Clear();
try
{
conn.Open();
int index = cmbEst.SelectedIndex + 1;
string query = "SELECT * FROM bicicleta WHERE id_estF = '" + index + "'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlCommand comando = conn.CreateCommand();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string patente = dr.GetString(0);
cmbPatente.Items.Add(patente);
}
}
catch (Exception ee)
{
throw ee;
}
finally
{
conn.Close();
}
}
private void ListadoEstacionamientos()
{
SqlConnection conn = mane.ConexionDBQuery();
try
{
conn.Open();
string query = "SELECT * FROM estacionamiento;";
SqlCommand cmd = new SqlCommand(query, conn);
SqlCommand comando = conn.CreateCommand();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string nombreEst = dr.GetString(1);
cmbEst.Items.Add(nombreEst);
cmbEst2.Items.Add(nombreEst);
}
}
catch (Exception zz)
{
throw zz;
}
finally
{
conn.Close();
}
}
