Some File Types pulled from Image field corrupted when using Response.Binary Write() to download...

[Charlie]

Hi:

I'm uploading documents into a SQL Server Image field and using
Response.Binary Write() to download or view them in the browser. Some doc
types like Adobe Illustrator and Photoshop files will open correctly, but
other like Word, Excel and Powerpoint are corrupt. Here is code fragment to
upload:

// Get file in byte array
int fileLen = this.TextBoxFil eToUpload.Poste dFile.ContentLe ngth;
byte[] arrayFile = new byte [fileLen];
Stream strm = this.TextBoxFil eToUpload.Poste dFile.InputStre am;
string contentType = this.TextBoxFil eToUpload.Poste dFile.ContentTy pe;
strm.Read(array File, 0, fileLen);

// Run insert commands...

Here is download code fragment:

// Get data into a reader...

// write to browser
Response.Conten tType = reader["ContentTyp e"].ToString();
Response.Append Header("Content-Disposition", "attachment ; filename = " +
fileName);
Response.Binary Write((byte[]) reader["FileConten ts"]);

Should work, seems like I'm missing something.

Thanks,
Charlie

[Arlyn]

I am using vb.net and I have got it working uploading and retrieving files
into an image datatype. The only type I havent got to work is pdf.

Here is my code:
' Uploading
fLen = myFile.ContentL ength

Dim fBuffer(fLen) As Byte

myFile.InputStr eam.Read(fBuffe r, 0, fLen)

' myFile is of type HttpPostedFile
dr("mcontent") = fBuffer

dr("ilength") = fLen

'Downloading

dr = dt.Rows(0)

Dim fBuffer(dr("ile ngth")) As Byte

fBuffer = dr("mcontent")

Response.Conten tType = dr("cContentTyp e")

'Response.Conte ntType = "applicatio n/octet-stream"

Response.AddHea der("Content-Disposition", _

"attachment ; filename=" & dr("cfilename") )

Response.Output Stream.Write(fB uffer, 0, dr("ilength")

I hope this helps

"Charlie@CB FC" <ch*****@comcas t.net> wrote in message
news:eB******** ******@TK2MSFTN GP15.phx.gbl...

Hi:

I'm uploading documents into a SQL Server Image field and using
Response.Binary Write() to download or view them in the browser. Some doc
types like Adobe Illustrator and Photoshop files will open correctly, but
other like Word, Excel and Powerpoint are corrupt. Here is code fragment
to
upload:

// Get file in byte array
int fileLen = this.TextBoxFil eToUpload.Poste dFile.ContentLe ngth;
byte[] arrayFile = new byte [fileLen];
Stream strm = this.TextBoxFil eToUpload.Poste dFile.InputStre am;
string contentType = this.TextBoxFil eToUpload.Poste dFile.ContentTy pe;
strm.Read(array File, 0, fileLen);

// Run insert commands...

Here is download code fragment:

// Get data into a reader...

// write to browser
Response.Conten tType = reader["ContentTyp e"].ToString();
Response.Append Header("Content-Disposition", "attachment ; filename = " +
fileName);
Response.Binary Write((byte[]) reader["FileConten ts"]);

Should work, seems like I'm missing something.

Thanks,
Charlie