How to upload .doc file into DataBase(SQLSERVER2005) and how to retrive it from DB

• • Reply

  12 years ago

  by FaulstiR

  Ricky

  , United States

  Joined 13 years ago

  Hi 2 all,

            How to upload .doc file into DataBase(SQLSERVER2005) and how to retrive it from DB

  and i want it in Windows Application c# only...not in Web...

  i know this in Web using FileUpload Control...so, i want it in Windows only..... 

  Ex : if i take one Resume...then how can i save this doc into DB and how to retrive it from DB again....

   

  Please help me..................it's very urgent..........
  

   

  Thanqqqqqqqqqqqqq
   

  Report abuse
• • Reply

  12 years ago

  by faizjmc

  faizal mohamed

  , India

  Joined 14 years ago
  Load the .doc file into filestream then using StreamReader convert into byte[], store it in DB in text datatype
  Report abuse
• • Reply

  12 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  This article shows you what you need to do.
  

  http://support.microsoft.com/kb/308042
  

  In the section where the filestream is created during the file upload, the location of the file is hard-coded. If you want the user to be able to select a file, you can use the OpenFileDialog control on your form.
  

  http://msdn.microsoft.com/en-us/library/7684e2s0.aspx
  

   

  Report abuse