OK, i have read various different opinion on whether a file should be inserted into a database, or whether it should be accessed through the filesystem. I really havent made up my mind which way to go on this, but i can already think of a few problems with both. I hope someone can help.
If you store the PDF inside a SQL database (lets say using an Image type), when you want to retrieve it...how do you view it? Ordinarily, with a file i would view with either the webbrowser control or the adobe reader activeX control, but both need a filename/source and dont seem to be able to view from a memorystream or byte array.
If i store the file using the filesystem on the server, and store the path in the database...how does a local user retrieve the file when they are working offsite, remotely? They can access the file using the path to the server when they are connected on the LAN, but when they are not, and just accessing the SQL server through the interner, how do they get access to the files then?
I would really like to know the best way to proceed as both ways seem problematic, yet i do need a solution.
Thanks so much,
In that case you'll need to put them in a database, or create a shared folder on the webserver where the necessary files are stored (but if there are a lot of files, you won't have enough space probably)
HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET
Read / Write BLOBs from / to SQL Server using C# .NET DataReader