How to open another page when hyperlink in gridview is clicked

See more:

ASP.NET

MySQL

Gridview

So I've created 2 pages, Rental.aspx (the page that will appear when hyperlink is clicked) and BookList.aspx (The page where the linkbutton is displayed).
For the Rental page, I used Gridview with BookTitle and Inputs inside. I thought of making the GridView to display only rows of bookTitle(hyperlink) selected from the BookList page.

I've also created 2 MySQL tables like this:
1) Table: rent
Columns: booktitle, date, name, memberID, phone, signIn
2) Table: booklist
Columns: id, booktitle, availability

Codes

BookList.aspx GridView part:

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataKeyNames="id" OnRowDeleting="GridView1_RowDeleting"  >
    <Columns>
        <asp:TemplateField HeaderText="Id">
            <ItemTemplate>
                <asp:Label ID="Label5" runat="server" Text='<%# Eval("id") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Book Title">
            <ItemTemplate>
           <asp:LinkButton ID="bookTitle" OnClick="link_Click" Text='<%# Eval("bookTitle") %>' runat="server" ></asp:LinkButton>

            </ItemTemplate>
        </asp:TemplateField>

        <asp:TemplateField HeaderText="Availability">

            <ItemTemplate>
                <asp:Label ID="Label4" runat="server" Text='<%# Eval("availability") %>'></asp:Label>
            </ItemTemplate>

        </asp:TemplateField>



        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID="delete" CommandName="Delete" runat="server">Delete</asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>

BookList.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.Adapters;
using System.Data;
using MySql.Data.MySqlClient;
using System.Windows;

namespace Library_System
{
    public partial class WebForm3 : System.Web.UI.Page
    {
        DataSet myData = new DataSet();
        MySqlConnection conn = new MySqlConnection();
        protected void Page_Load(object sender, EventArgs e)
        {
           conn.ConnectionString = "server=127.0.0.1;database=test;port=3306;username=root;password=";
            if(!IsPostBack)
            {
                BindData();
       
            }
          
        }
   private void BindData()
        {
            DataTable dt = new DataTable();
            using (conn)
            {
                MySqlDataAdapter adp = new MySqlDataAdapter("select * from test.booklist", conn);
                adp.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
            }
        }

        protected void link_Click(object sender, EventArgs e)
        {
            Response.Redirect("Rent.aspx?bookTitle=" + ((LinkButton)sender).Text);

        }

Rent.aspx

<asp:GridView ID="GridView1" runat="server" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" AutoGenerateColumns="False"  OnRowUpdating="GridView1_RowUpdating">
            <Columns>
                <asp:TemplateField HeaderText="Book Title">
                    <ItemTemplate>
                        <asp:Label ID="book" runat="server" Text='<%# Eval("bookTitle") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Date">
                    <ItemTemplate>
                        <asp:TextBox ID="date" runat="server" Text='<%# Eval("date") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Name">
                    <ItemTemplate>
                        <asp:TextBox ID="name" runat="server" Text='<%# Eval("name") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Member ID">
                    <ItemTemplate>
                        <asp:TextBox ID="memberID" runat="server" Text='<%# Eval("memberID") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Phone">
                    <ItemTemplate>
                        <asp:TextBox ID="phone" runat="server" Text='<%# Eval("phone") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Sign In">
                    <ItemTemplate>
                        <asp:ImageButton ID="signIn" runat="server" AlternateText="On Rent" ImageUrl="~/Images/unclick.png" OnClick="SignIn_Click" />
                    </ItemTemplate>
                </asp:TemplateField>
            
                <asp:TemplateField>

                    <ItemTemplate>
                        <asp:LinkButton ID="submit" runat="server" Text="Submit" style="background-image: url(~/Images/save)" CommandName="Update"></asp:LinkButton>
                    </ItemTemplate>

                </asp:TemplateField>

Rent.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using MySql.Data.MySqlClient;
using System.Windows;


namespace Library_System
{
    public partial class _new : System.Web.UI.Page
    {
        DataSet myData = new DataSet();
        MySqlConnection conn = new MySqlConnection();
        protected void Page_Load(object sender, EventArgs e)
        {
            conn.ConnectionString = "server=127.0.0.1;database=test;port=3306;username=root;password=";
            if (!IsPostBack)
            {
                BindData();
               
            }
        }

        private void BindData()
        {
            string bookTitle = Request.QueryString["bookTitle;"];
            conn.Open();
            DataTable dt = new DataTable();
       
                MySqlCommand cmd = new MySqlCommand("select a.bookTitle from booklist a, rent b where a.bookTitle = b.bookTitle;" + "select * from test.rent where bookTitle= @bookTitle; ", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                MySqlParameter p = new MySqlParameter("@bookTitle", bookTitle);
                cmd.Parameters.Add(p);
                MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
                
                adp.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
            
        }

I think I'm able to click the hyperlink from booklist but when it's redirecting, the error was shown in rent.aspx.cs near the "adp.Fill(dt);"