PDF download doesnt work, instead opening unreadable in browser

manpreet Best Answer 3 years ago

I have an asp.net application which allows user to download PDF files. but instead of downloading it, the browser opens the file with unreadable block characters.

Download Code

Protected Sub btn_dwnd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_dwnd.Click
    cn.Open()

    cmd.CommandText = "Select * from Syllabus where file_name ='" & txtdwd_file.Text & "'"
    cmd.Connection = cn
    dr = cmd.ExecuteReader
    Do While dr.Read
        Response.WriteFile(dr("file_name"))

    Loop
    cn.Close()
End Sub

I am trying to download my uploaded pdf file in my project's root directory D:\OLMS when I click download unreable characters opens up in browser (square characters). I think it opens up pfd file in browser

Upload Code

Protected Sub btnadd_sylbus_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnadd_sylbus.Click
    Dim extension As String = System.IO.Path.GetExtension(FileUpload_sylbus.PostedFile.FileName).ToLower()
    Dim Type As String = Nothing
    If (extension = ".pdf") Then
        Dim strFileNamePath As String
        Dim strFileNameOnly As String
        strFileNamePath = FileUpload_sylbus.PostedFile.FileName
        strFileNameOnly = Path.GetFileName(strFileNamePath)
        Dim newFileNamePath As String = Path.Combine("D:\OLMS", strFileNameOnly)
        Dim br As New BinaryReader(FileUpload_sylbus.PostedFile.InputStream)
        FileUpload_sylbus.PostedFile.SaveAs(newFileNamePath)
        cmd.CommandText = "INSERT into Syllabus(sylbus_id, sylbus_name, file_name, content) values(@id,@name,@file,@cont)"
        cmd.Connection = cn
        cmd.Parameters.Add("@id", txtsylbus_id.Text)
        cmd.Parameters.Add("@name", txtsylbus_name.Text)
        cmd.Parameters.Add("@file", FileUpload_sylbus.FileName)
        cmd.Parameters.
                                                

                                                                                                        
                                                    
                                                
                                                

                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares
                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp