protected void GenreButton_Click(object sender, EventArgs e)
{
cnDB.Open();
string inject = "";
string sql = "SELECT Movie.MovieTitle, Movie.ReleaseDate, Genre.GenreType FROM Genre INNER JOIN " +
"Movie ON Genre.GenreID = Movie.GenreID where GenreType = @gT";
if (genreRadioButtons.SelectedValue == "Action")
{
inject = "Action";
}
else if (genreRadioButtons.SelectedValue == "Comedy")
{
inject = "Comedy";
}
else if (genreRadioButtons.SelectedValue == "Drama")
{
inject = "Drama";
}
using (SqlCommand cmd = new SqlCommand(sql, cnDB))
{
cmd.Parameters.Add("@gT", SqlDbType.VarChar);
cmd.Parameters["@gT"].Value = inject;
SqlDataReader dr = cmd.ExecuteReader();
genreTable.Clear();
genreTable.Load(dr);
dr.Close();
}
cnDB.Close();
GenreGridView.DataSource = genreTable;
GenreGridView.DataBind();
}
private void UpdateGridData()
{
GenreGridView.DataSource = db.Genres.ToList();
GenreGridView.DataBind();
}
