Store and Retrieve Word document from SQL 2005 using vb 2008

[paullem]

Hi,

I have a vb.net application whereby the customer occasionally needs to store a word document alongside the other record details. I want to store the word document in the database and give the customer the facility to click a button to retrieve and update the document then store the updated document back in the database. Does anyone have any code examples I can look at or point me in the direction of a website that may help.

Many Thanks,

paullem

 

[jebenson]

Does the document itself need to be in SQL Server, or could you just store the path to the file on a file server?


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[paullem]

Hi jebenson,

Because it's only the occasional document I wanted to store it on the database rather than use a file on a file server (although that may turn out to be the easiest option!)

paullem