I'm working on a proof-of-concept idea for my boss to show him that we can suck in Word documents (resumes) and other binary data (pictures) into an SQL Server then display the data and maybe search on the text.
I have an SQL 2008 Server with a test table where I created some VARBINARY(MAX) fields -- one for a picture and one for a Word document. I founds some code to insert a row and populate the respective fields from respective file sources (a picture of me and my resume in Word).
I'm using Microsoft Visual Studio Express 2012 for Windows Desktop. I created a Windows Forms Application/Visual Basic sample form where I dropped some text and the picture image field on the form from the SQL DataSet.
What I don't know how to do is display the Word document from the VARBINARY(MAX) field. If I display it as a RichTextBox, it only shows "Byte Array".
Is there some type of Custom Control I need to add for this data type? If so, where can I find one and how do I add it?
Thanks in advance!