Thread: How can i store a doc or pdf file in SQL Server

hi guys,
on my project (working with c#-asp.net,SQL Server 2005) students upload their thesis to the system. i made the uploading form, i used the fileupload component for taking the thesis.

For now i used the image type for storing the thesis does it work?

i am waiting your opinions, thanks...

Store it as binary data. Or store the path on some filesystem that you can retrieve from. IE upload it somewhere, and store this path for later retrieval.

Agreed with Valaris. And specifically varbinary(max) if you're expecting files to be large.

thanks guys for your answers, i will made like valaris said, firstly i stored them somewhere then i will hold the path in database..

Bah! It's way more fun to store them in BLOBs in SQL. Give it a shot, it's not too difficult and then you're not relying on the file system maintaining it's structure.

firstly i wanted to store files in db, but after talking with my advisor he wants to store files in a folder in solution.

student can upload his/her these to the folder (in theses folder in the solution) and the path of theses are holded in db. how can i download the these file from the system?

Originally Posted by Aga^^

firstly i wanted to store files in db, but after talking with my advisor he wants to store files in a folder in solution.

student can upload his/her these to the folder (in theses folder in the solution) and the path of theses are holded in db. how can i download the these file from the system?

You have the path in the database. So provide a link to it. I don't know what web language you're using, but its quite trivial.

thanks valaris , i also thought that but i implemented wrongly, after your comment i tried again and got it.