results

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

<!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>
        </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 results1 : 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("Default.aspx");
        }
    }
}