private void rellenatabla()
{
MySqlConnection conexion = new ConexionBBDD().conecta();
MySqlCommand comando = new MySqlCommand("select * from prestamos", conexion);
MySqlDataReader resultados = comando.ExecuteReader();
datos.Load(resultados);
dataGridView1.DataSource = datos;
conexion.Close();
}
private void button1_MouseClick(object sender, MouseEventArgs e)
{
listaDatos.DataSource = null;
listaDatos.Rows.Clear();
if (desplegable.Text == "año")
{
lector = buscador.Text;
MySqlConnection conexion = new ConexionBBDD().conecta();
MySqlCommand comando = new MySqlCommand("select movies.id, movies.name, movies.year, movies.rank " +
"from movies " +
"where movies.year = " + lector, conexion);
MySqlDataReader resultados = comando.ExecuteReader();
datos.Clear();
datos.Load(resultados);
listaDatos.DataSource = datos;
conexion.Close();
}
if (desplegable.Text == "autor")
{
lector = buscador.Text;
MySqlConnection conexion = new ConexionBBDD().conecta();
MySqlCommand comando = new MySqlCommand("select movie.id, directors.id, directors.first_name, directors.last_name, movies.name as 'pelicula', movies.year " +
"from directors, movies, movies_directors " +
"where directors.first_name like '%" + lector +
" %' or directors.last_name like '%" + lector + "%' and directors.id = movies_directors.director_id" +
" and movies_directors.movie_id = movies.id"
, conexion);
MySqlDataReader resultados = comando.ExecuteReader();
datos.Clear();
datos.Load(resultados);
listaDatos.DataSource = datos;
conexion.Close();
}
if (desplegable.Text == "genero")
{
lector = buscador.Text;
MySqlConnection conexion = new ConexionBBDD().conecta();
MySqlCommand comando = new MySqlCommand("select movie.id, movies.name, movies.year " +
"from movies " +
"where movies.year = " + lector, conexion);
MySqlDataReader resultados = comando.ExecuteReader();
datos.Clear();
datos.Load(resultados);
listaDatos.DataSource = datos;
conexion.Close();
}
if (desplegable.Text == "titulo")
{
lector = buscador.Text;
MySqlConnection conexion = new ConexionBBDD().conecta();
MySqlCommand comando = new MySqlCommand("select movie.id, movies.name, " +
"from movies " +
"where movies.name like '% " + lector + "%'"
, conexion);
MySqlDataReader resultados = comando.ExecuteReader();
datos.Clear();
datos.Load(resultados);
listaDatos.DataSource = datos;
conexion.Close();
}
}