SIGN UP MEMBER LOGIN:    
ARTICLE

Convert WinWord Document to Blob

Posted by Sanat Palia Articles | Visual C# February 27, 2008
This article tells you how to convert WinWord document to Blob and save it in a datarow.
Reader Level:

I have used a Winword Control to display the word document in a windows forms. Couple of my friends asked me how to save the document as a blob in to a database. So I thought of putting an article about it. The code is very Simple. Just use file system to convert the document to array of bytes[]

try
{
   
//Delete the doc file used for Saving if already exists
   
FileInfo mySaveFile = new FileInfo(@"C:\mysavefilename.doc");
   
if (mySaveFile != null)
   
{
       
mySaveFile.Delete();
   
}
   
object overWriteExisting = false;
   
object refMissing = Missing.Value;
   
object saveFileName = _filenameSave;
   
this.myWinWordControl.document.SaveAs(ref saveFileName, ref refMissing, ref refMissing, ref refMissing, ref refMissing, ref 
    refMissing,ref refMissing, ref refMissing, ref refMissing, ref refMissing, ref refMissing);
    //Show Blank document so that the current loaded file gets released
   
ShowBlankDocument();
   
//convert the doc file to blob.
   
MyDS.mYRow row = null;
   
FileStream fls;
   
fls = new FileStream(_filenameSave, FileMode.Open, FileAccess.Read);
   
//a byte array to read the doc
   
byte[] blobDoc = new byte[fls.Length];
   
fls.Read(blobDoc, 0, System.Convert.ToInt32(fls.Length));
   
fls.Close();
   
if (this._presenter.IsNewRecord)
   
{
       
_mYDS = new mYDS();
       
row = _mYDS.MyTable.NewRow();
       
row.MY_DOC = blobDoc;
       
return _presenter.AddRecord(row);
   
}
   
else
   
{
       
row = mYDS.Rows[0];
       
row.MY_DOC = blobDoc;
       
return _presenter.UpdateRecord(row);
   
}
}

catch (Exception exp)
{
   
_ErrorWindow.Show(exp);
   
return false;
}
 
The DataSet row conataining the blob can be saved with regular saving technique using Enterprise Libararies DAL.

Login to add your contents and source code to this article
share this article :
post comment
 

How to convert all content of richtextbox with image,fontstyle to html in vb.net

Thanks with regards.

Posted by Parkash Kaur Mar 16, 2010
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
PREMIUM SPONSORS
  • Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
    Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor