[Solved] Export GridView to PDF Error: Incorrect syntax near

good morning,

I try to create a button to do the pdf file export by using the code below. Unfortunately, they keep telling me that I have the “Syntax Error”

can you help me to take a look at my code, and help me to fix the Syntax Error for me please?

Thank you so much.

    Private Function GetData(ByVal cmd As SqlCommand) As DataTable
        Dim dt As New DataTable()
        Dim connString As String = ConfigurationManager.ConnectionStrings("DBHUSRConnectionString").ConnectionString
        Dim DBConnection As SqlConnection = New SqlConnection(connString)
        Dim sda As New SqlDataAdapter()
        cmd.CommandType = CommandType.Text
        cmd.Connection = DBConnection
        Try
            DBConnection.Open()
            sda.SelectCommand = cmd
            sda.Fill(dt)
            Return dt
        Catch ex As Exception
            Throw ex
        Finally
            DBConnection.Close()
            sda.Dispose()
            DBConnection.Dispose()
        End Try
    End Function

    Protected Sub ExportToPDF_Click(sender As Object, e As EventArgs) Handles ExportToPDF.Click
        Dim strQuery As String = "SELECT STUDENTSPLACEMENTS.AutoNum, STUDENTSPLACEMENTS.StudCWID, STUDENTSPLACEMENTS.TermID, STUDENTSPLACEMENTS.FWCourse, STUDENTS.STUDLastname, STUDENTS.STUDFirstname, [STUDfirstname] + ' ' + [STUDLastname] AS Student, STUDENTSPLACEMENTS.OrgCode, STUDENTSPLACEMENTS.SupervisorName, STUDENTSPLACEMENTS.InstructorName, STUDENTSPLACEMENTS.OPPhone, STUDENTSPLACEMENTS.SPNotes, STUDENTSPLACEMENTS.ContactDate" _
                                        & "FROM STUDENTSPLACEMENTS" _
                                        & "INNER JOIN STUDENTS ON STUDENTSPLACEMENTS.StudCWID = STUDENTS.STUDCWID" _
                                        & "WHERE STUDENTSPLACEMENTS.InstructorName= 'FacID' AND STUDENTSPLACEMENTS.TermID = 'TermID' AND STUDENTSPLACEMENTS.FWCourse = 'DropDownList2'" _
                                        & "GROUP BY STUDENTSPLACEMENTS.AutoNum, STUDENTSPLACEMENTS.StudCWID, STUDENTSPLACEMENTS.TermID, STUDENTSPLACEMENTS.FWCourse, STUDENTS.STUDLastname, STUDENTS.STUDFirstname, STUDENTSPLACEMENTS.OrgCode, STUDENTSPLACEMENTS.SupervisorName, STUDENTSPLACEMENTS.InstructorName, STUDENTSPLACEMENTS.OPPhone, STUDENTSPLACEMENTS.SPNotes, STUDENTSPLACEMENTS.ContactDate" _
                                        & "ORDER BY STUDENTSPLACEMENTS.FWCourse"


        Dim cmd As New SqlCommand(strQuery)
        Dim dt As DataTable = GetData(cmd)
        Dim GridView1 As New GridView()
        GridView1.AllowPaging = False
        GridView1.DataSource = dt
        GridView1.DataBind()
        Response.Clear()
        Response.Buffer = True
        Response.AddHeader("content-disposition", "attachment;filename=FacultyTeachingCourse.pdf")
        Response.Charset = ""
        Response.ContentType = "application/vnd.ms-word"
        Dim sw As New StringWriter()
        Dim hw As New HtmlTextWriter(sw)
        GridView1.RenderControl(hw)
        Response.Output.Write(sw.ToString())
        Response.Flush()
        Response.End()
    End Sub