Hi Virendrasinh,
Thank you for your interest with Syncfusion Essential DocIO.
Yes, we do have support for getting both BLOB images and documents from database. Just we getting either BLOB document or image from database and then need to convert it as binary stream. Because we have WordDocuement Class for creating or opening an Existing document with WordDocuement (Stream, FormatType) overloads. This helps us to create or open a document from streams. Here is a small code snippet for your reference.
// Casting the BLOB document into byte array.
byte[] docStream = ( row[ "doc" ] as byte[] );
WordDocument doc = new WordDocument();
// Open the document by Streams with byte array.
doc.Open ( new MemoryStream( docStream ) , FormatType.Doc );
Also, we can insert a BLOB images to the document. We can get the BLOB image field from the table and need to convert it as binary stream. Then we can pass the binary stream value to AppendImage( Image ) overlaod. Here is a small code snippet for your reference.
// getting Employee images from database.
byte[] ImageBytes = ( row[ "Photo" ] as byte[] );
//Writing image to the document.
paragraph.AppendPicture ( Image.FromStream ( new MemoryStream ( ImageBytes ) ) );
I have use Access database for getting BLOB documents and images. Please refer Syncfusion assemblies from “Assemblies” folder in the attachment.
Here is a sample for your reference :
Sample_BLOB.zip
Please let me know if you have any questions.
Thanks,
Prabhu.
>Hi,
>
>If we have an image stored as a BLOB and the word document in a BLOB as well, can the image then be inserted into the document dynamically without saving on the server???
>
>Thanks and Regards,
>Virendrasinh More.
