loggedinresults

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="loggedinResults.aspx.cs" Inherits="MovieDatabase.results" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

<asp:gridview ID="Gridview1" runat="server"
                             AutoGenerateColumns="true">
        <Columns>
        <asp:TemplateField HeaderText="">
            <ItemTemplate>
                <asp:Button ID="Favorite" Text= "Make Favorite Movie" runat="server"></asp:Button>
            </ItemTemplate>
        </asp:TemplateField>
        </Columns>
</asp:gridview>
        <br />
        <asp:Button ID="BackButton" runat="server" Text="Back to Home Page" OnClick="BackButton_Click" />
        </div>
    </form>
</body>
</html>


using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace MovieDatabase
{
    public partial class results : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

            OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["MovieDatabase"].ConnectionString);

            string query = ("SELECT TITLE, BUDGET, RELEASEYEAR, GENRE, ADDEDBY FROM MOVIE WHERE TITLE LIKE @title");
            connection.Open();
            OleDbCommand cmd = new OleDbCommand(query, connection);
            cmd.Parameters.AddWithValue("@title", "%" + Session["searchTitle"] + "%");
            OleDbDataReader reader = cmd.ExecuteReader();


            // Response.Write("<table border=\"2\">" + "<tr>" + "<th> Title </th>" + "<th> Budget </th>" +
            //  "<th> Release Year </th>" + "<th> Genre </th>" +
            //  "<th> Added By </th>" + "<th> Movie ID </th>" + "<th> Make This Movie Your Favorite </th>" + "</tr>");
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("Title", typeof(string)));
            dt.Columns.Add(new DataColumn("Budget", typeof(string)));
            dt.Columns.Add(new DataColumn("Release Year", typeof(string)));
            dt.Columns.Add(new DataColumn("Genre", typeof(string)));
            dt.Columns.Add(new DataColumn("Added By", typeof(string)));

            while (reader.Read())
            {
                DataRow drCurrentRow = dt.NewRow();
                drCurrentRow["Title"] = reader["TITLE"].ToString();
                drCurrentRow["Budget"] = reader["BUDGET"].ToString();
                drCurrentRow["Release Year"] = reader["RELEASEYEAR"].ToString();
                drCurrentRow["Genre"] = reader["GENRE"].ToString();
                drCurrentRow["Added By"] = reader["ADDEDBY"].ToString();
                dt.Rows.Add(drCurrentRow);
            }
            Gridview1.DataSource = dt;
            Gridview1.DataBind();


            //    Response.Write("<tr>" + "<td><i>" + reader["TITLE"] +
            //   "<td>" + reader["BUDGET"] + "</td>" + "<td>" + reader["RELEASE YEAR"] + "</td>" +
            //   "<td>" + reader["GENRE"] + "</td>" + "<td>" + reader["ADDED BY"] + "</td>" + "<td>" +
            //   reader["MOVIE ID"] + "</td>" + "<td>" + "</tr>");
        }

        protected void BackButton_Click(object sender, EventArgs e)
        {
            Response.Redirect("searchLoggedIn.aspx");
        }
    }
}