Word document saved to SQL Server as Image - retrieves incorrectly

[K B]

I'm using the following in .NET to save a Word document to a SQL image
column:

Dim iImageSize As Integer = FileUpload.Post edFile.ContentL ength
Dim picbyte() As Byte = New Byte(iImageSize ) {}
FileUpload.Post edFile.InputStr eam.Read(picbyt e, 0, iImageSize)

Seems to work fine, but when I retrieve the image and use the following
to load it, I get a lot of characters, etc. What am I doing wrong
please?

Response.Clear
Dim arrImage() As Byte = DirectCast(Sess ion("ImageConte nt"), Byte())
Dim ms1 As New System.IO.Memor yStream(arrImag e)
Response.Binary Write(arrImage)
Response.Conten tType = Session("Conten tType")
Response.Output Stream.Write(CT ype(Session("Im ageContent"), Byte()), 0,
CInt(Session("I mageSize")))
Response.End()

I get the content but with a lot of extra stuff in it:

ÐÏࡱá>þÿ
áã
þÿÿÿßàÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿì¥Á` ø¿æ"bjbjËs Ës

©
Ê
ÿ ÿÿÿÿÿ¤ˆˆˆ ˆˆˆˆœ„I„I „I8¼Id
J,
œ›h
XKXK^¶ K¶KâKÞNR0OLO� šƒšƒšƒšƒšƒšƒš$ jœhÒžL
§šˆ‡R žNžN@‡R‡R§šˆ
ˆ¶KâK¼¼šgUg UgU‡Rdˆ¶KˆâK� šgU‡R�šgUgU2� ¨
ˆˆÙ�¶K,LK
°öŸ«
vÆ
„IëRp½Ž b-•TÒš0›�º
 [S¨
 \Ù�
ˆñ�<\O„àO^gU> PLŠPý
\O\O\O§š§ šUd\O\O\O›‡R‡ R‡R‡Rœœœd8„ œœœ8œœ
œˆˆˆˆˆˆÿ ÿÿÿ
To:

*** Sent via Developersdex http://www.developersdex.com ***

[Winista]

All MS Office applications use OLE Document format to store the data and a
lot of time you will find buffer bytes used as paddind to fillers to fill
512byte blocks. MS Office applications know how to read them back. Do a
simple test, read the data back into a word file and if it opens and
contents are intact.
"K B" <ka**********@c omcast.net> wrote in message
news:ej******** *****@TK2MSFTNG P02.phx.gbl...

I'm using the following in .NET to save a Word document to a SQL image
column:

Dim iImageSize As Integer = FileUpload.Post edFile.ContentL ength
Dim picbyte() As Byte = New Byte(iImageSize ) {}
FileUpload.Post edFile.InputStr eam.Read(picbyt e, 0, iImageSize)

Seems to work fine, but when I retrieve the image and use the following
to load it, I get a lot of characters, etc. What am I doing wrong
please?

Response.Clear
Dim arrImage() As Byte = DirectCast(Sess ion("ImageConte nt"), Byte())
Dim ms1 As New System.IO.Memor yStream(arrImag e)
Response.Binary Write(arrImage)
Response.Conten tType = Session("Conten tType")
Response.Output Stream.Write(CT ype(Session("Im ageContent"), Byte()), 0,
CInt(Session("I mageSize")))
Response.End()

I get the content but with a lot of extra stuff in it:

ÐÏࡱá>þÿ
áã
þÿÿÿßàÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿì¥Á` ø¿æ"bjbjËs Ës

©
Ê
ÿ ÿÿÿÿÿ¤^^^ ^^^^o"I"I "I8¼Id
J,
o>h
XKXK^¶ K¶KâKÞNR0OLO� sfsfsfsfsfsfs$ johÒzL
§s^?R zNzN@?R?R§s^
^¶KâK¼¼sgUg UgU?Rd^¶K^âK� sgU?R�sgUgU2� ¨
^^Ù�¶K,LK
°öY«
vÆ
"IëRp½Z b-.TÒs0>�º
 [S¨
 \Ù�
^ñ�<\O"àO^gU> PLSPý
\O\O\O§s§ sUd\O\O\O>?R? R?R?Roood8" ooo8oo
o^^^^^^ÿ ÿÿÿ
To:

*** Sent via Developersdex http://www.developersdex.com ***