Opening a file stored in a database in .NET

Question

I'm storing a Word document in a SQL Server 2005 database in a varbinary(max) column. Is there a way to open this document from a VB.NET Windows Forms application without serialising to a file first (i.e. directly from the byte array I've read from the database)?

Chris Wenham · Accepted Answer · 2008-09-11 15:41:25Z

3

Depends on what's reading it. If it's Word, you'll probably have to serialize to a file, but if it's a function or library that can take an IO.Stream then you could wrap a new MemoryStream around the byte array and pass that.

answered Sep 11, 2008 at 15:41

Chris Wenham

24.1k13 gold badges62 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joel Coehoorn · Accepted Answer · 2008-09-11 15:37:02Z

2

Not really. You need to treat it like an e-mail attachment, where the file is generally copied to a temp folder that is cleaned out periodically.

answered Sep 11, 2008 at 15:37

Joel Coehoorn

419k114 gold badges582 silver badges820 bronze badges

Collectives™ on Stack Overflow

Opening a file stored in a database in .NET

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related