Member Avatar for Zulu79

I was able to store the PDF. Now the issue is retreving the correct version of the PDF. I am storing it with the data fields filled in;however, upon retrevial the fields are blank.

Dim reader As System.Data.SqlClient.SqlDataReader = Local_Command.ExecuteReader()
        Dim buffer(100000) As Byte 
        Dim data As Byte()
        While reader.Read
            data = reader("pdfcontents")
        End While
        System.IO.File.WriteAllBytes("c:/file.pdf", data)
        Local_Command.Dispose()
        Local_Connection.Close()
  • 2 Contributors
  • 1 Reply
  • 103 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Ancient Dragon
Member Avatar for Ancient Dragon

What sql server are you using? Have you use a server system tool to verify the data was stored correctly? With MySQL there is an admin tool you can use to do that, I'm certain most other SQL servers have something similar.

This may not be relevant, but shouldn't there be a () after Read?
While reader.Read()

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.