I searched for it, searched for it, browsed through SO and other sites (I tried to read on this issue for hours now), but I still cannot find a satisfactory solution to what seems to be a simple, general programming problem.
Let me set the scene:
- I have a website / web application that allows a user to search the SQL Server library.
- Most documents related to search results are PDF files.
- PDF files are stored inside the SQL Server BLOB database.
- I want to be able to dynamically extract PDF from a database and display it to the user.
- To save the user's search progress, I would like to open the file in another browser window / tab
- I figured out how to save the PDF file on the server in the specified directory.
- I DO NOT want the user to see the path to the file.
- For a reason, I want a solution that works in all major browsers:
- Internet explorer
- Firefox
- Chrome
- Safari (including iPhone Safari Mobile Safari)
- I would prefer not to buy a third-party component, but I am ready to go along this route, if necessary.
- I donβt think I want to send the file as a downloadable file (which, I think, I figured out how to do it) because it wonβt work on the iPhone / iPad?
Each solution I have tried so far contains some basic problems:
- Using iFrames seems to fail on iPhone / iPad
- Using Server.Transfer (I use ASP.NET) shows gibberish instead of PDF
- I tried a couple of third-party demos, but they stink too!
I can't figure it out! I am truly a desktop developer and it was EASY on Windows! Why is it so complicated with the internet?
Am I really stupid, and is this really an easy exercise, or is this basic task really so difficult?
Please help point me in the right direction!
Thanks!!!
source share