I am storing files in SQL using FileStream from a ASP .NET app. I am also storing the filetypes.
I want to allow users to download (and open these files) to view them. I see a lot of code samples on how I can read data out of FileStream, and put it into a buffer in memory. I guess from there, I can write it out to a file.
But since the data is already in a file (SQL "Select myFileStreamColumn.FilePath()" returns it's location) can't I somehow put up a Save As... dialog for the user, and let them download it directly from the SQL storage area to their local PC?
Do I have to read the data out of SQL, write it out to a file, and then give them a Save As... dialog pointing to that new file?
I know I'm missing something basic here. What is it?
Thanks.
...
Go to the complete details ...