What is the best way to store and retrieve files in asp.net web application

Posted by Niharikap under ASP.NET on 10/1/2012 | Points: 10 | Views : 7933 | Status : [Member] | Replies : 4
Hi,

I have requirement to store files which may be images,microsoft documents,videos, audio files and other files in web application.

Can you please which way is good to store files either SQL Server or different folder in the web server?

Thanks,




Responses

Posted by: Vivekjj on: 10/1/2012 [Member] Starter | Points: 25

Up
0
Down
As per my self different folder is best way because in sql server its some difficult to retrieve the documents and etc..,

Niharikap, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ankit_Parmar555 on: 10/1/2012 [Member] Starter | Points: 25

Up
0
Down
you can store only file name in attachment table in db.
it is one of the best way to store attachments.

Niharikap, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Divyaselvarathinam on: 10/3/2012 [Member] Starter | Points: 25

Up
0
Down
Using web server foldes and filename alone in sql server is the easiest way..

but if u r conscious of system memory then avoid folders, u can store the contents in sql server itself

And also if u use folders there may be a chance of the files getting deleted physically

My suggestion is to use Sql Server

Divya

Niharikap, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vforvijay on: 10/4/2012 [Member] Starter | Points: 25

Up
0
Down
hi..
The best way you store the file into database by using binary conversion,its safe and secure...Refer the below links for the process
http://www.dotnetcode.in/2012/06/upload-and-download-file-from-database.html


Niharikap, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response