Where should I save uploaded files?

I have a requirement to upload files in our asp.net app. These files have medical info about patients. I need to encrypt them or somehow protect the content.

They're mostly PDF files. What do i need to do? i worked on a sql 2000 app years ago and we
saved the documents in the database but i think it's not recommanded by MS to save docs in the database. What do I need to do?

Should I use FileStream?
LVL 8
CamilliaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

micropc1Commented:
What about encrypting and storing the file on the file system, and storing the path to the encrypted file in the database?  http://support.microsoft.com/kb/307010
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Easwaran ParamasivamCommented:
http://support.microsoft.com/kb/323246 You can use FileUpload control of either ASP.NET or HTML control. On uploading call the SaveAs method. Specify the location where to store the file. My suggestion is have Appsetting in web.config file and specify common folder say for example <appsetting key="CommonFolder" value="C:\UploadeFiles\" /> and read the config entry in application and append the Unique file name to it. While retrieving the file please do follow the same. In later point of time you can change the folder path. Please note that the folder could be network path as well (should have Read/Write Permission).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.