Ejemplo n.º 1
0
 private void GetData(string filmTitle)
 {
     try
     {
         SQL = "SELECT actor.`first_name`,actor.`last_name`" + Environment.NewLine +
               "FROM actor" + Environment.NewLine +
               "Left JOIN film_actor ON actor.`actor_id`= film_actor.`actor_id`" + Environment.NewLine +
               "Left JOIN film ON film_actor.`film_id`= film.`film_id`" + Environment.NewLine +
               "WHERE film.`title`=" + My.Quote(filmTitle);
         cmd.CommandText = SQL;
         reader          = cmd.ExecuteReader();
         dtActors.Rows.Clear();
         dtActors.Load(reader);
         dgvActors.DataSource = dtActors;
         lblActors.Text       = "Actors Found: " + dtActors.Rows.Count.ToString();
         if (reader != null)
         {
             reader.Close();
         }
     }
     catch (Exception exc)
     {
         MessageBox.Show(exc.ToString());
     }
 }
Ejemplo n.º 2
0
        private void ShowFilms()
        {
            int    categoryID;
            string sWHERE = string.Empty;

            try
            {
                SQL = "SELECT" + Environment.NewLine +
                      "`film`.`film_id`     AS `FID`," + Environment.NewLine +
                      "`film`.`title`       AS `title`," + Environment.NewLine +
                      "`category`.`name`    AS `category`," + Environment.NewLine +
                      "`film`.`length`      AS `length`," + Environment.NewLine +
                      "`film`.`rating`      AS `rating`," + Environment.NewLine +
                      "`film`.`rental_rate` AS `price`," + Environment.NewLine +
                      "film.`special_features` AS special_features," + Environment.NewLine +
                      "film.`rental_duration` AS rental_duration," + Environment.NewLine +
                      "film.`replacement_cost` AS replacement_cost," + Environment.NewLine +
                      "`film`.`description` AS `description`" + Environment.NewLine +
                      "FROM category" + Environment.NewLine +
                      "LEFT JOIN film_category ON category.`category_id`= film_category.`category_id`" + Environment.NewLine +
                      "LEFT JOIN film ON film_category.`film_id`= film.`film_id`" + Environment.NewLine;

                sWHERE = " Where film.`title` LIKE " + My.Quote(txtMovieName.Text + "%");
                if (cbxCategories.SelectedIndex != -1)
                {
                    CategoryID a = (CategoryID)cbxCategories.SelectedItem;
                    categoryID = Convert.ToInt32(a.id);
                    sWHERE    += " AND category.`category_id`=" + categoryID;
                }

                if (txtMovieName.Text != string.Empty || cbxCategories.SelectedIndex != -1)
                {
                    SQL += Environment.NewLine + sWHERE;
                }
                cmd.CommandText = SQL;
                reader          = cmd.ExecuteReader();

                tblMovies.Rows.Clear();
                tblMovies.Load(reader);
                dvgMovies.DataSource = tblMovies;
                lblMovies.Text       = "Movies Found: " + tblMovies.Rows.Count.ToString();
                if (reader != null)
                {
                    reader.Close();
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.ToString()); }
            finally
            {
                //reader?.Close();
            }
        }