C# Web App: Retrieving documents stored in SQL

[dmj07]

Hi,

I need some help retrieving documents I have inserted into SQL in an Image type field. What I want to get is that when the user clicks the view button it retrieves the document in the format it was saved as. Code is below:

SqlConnection connSQL = new SqlConnection(conn);
connSQL.Open();
 
SqlCommand cmdHeader = new SqlCommand("SELECT Title, Attachment, Attachment_Type FROM MDM_REQUEST_ATTACHMENTS Attachment_ID = 10", connSQL);
cmdHeader.CommandType = CommandType.Text;
SqlDataReader rdrRead = cmdHeader.ExecuteReader();
rdrRead.Read();
 
Response.ContentType = rdrRead[2].ToString();
Response.AddHeader("Content-Disposition", "attachment; filename=" + rdrRead.GetString(0));
Response.Write((byte[])rdrRead[1]);            
Response.End();
 

At the moment this just opens up Microsoft Word and displays System.Byte[] rather than the word "Test" which was saved in the file befor it was inserted :(

Many thanks in advance.

[Curtis Rutland]

Perhaps try Response.Binary Write. Or save it to a file and use Response.WriteF ile.

[mldisibio]

// ACKNOWLEDGEMENT: http://www.c-sharpcorner.com/Code/2004/March/DownloadingFromMemStream.asp
private void Page_Load(object sender, System.EventArgs e){
//Create and populate a memorystream with the contents of the database table
System.IO.MemoryStream mstream = GetData();
 
//Convert the memorystream to an array of bytes.
byte[] byteArray = mstream.ToArray();
 
//Clean up the memory stream
mstream.Flush();
mstream.Close();
// Clear all content output from the buffer stream
Response.Clear();
 
// Add a HTTP header to the output stream that specifies the default filename for the browser's download dialog
Response.AddHeader("Content-Disposition", "attachment; filename=foo.xls");
 
// Add a HTTP header to the output stream that contains the content length(File Size). 
// This lets the browser know how much data is being transfered
Response.AddHeader("Content-Length",
byteArray.Length.ToString());
 
// Set the HTTP MIME type of the output stream
Response.ContentType = "application/octet-stream";
 
// Write the data out to the client.
Response.BinaryWrite(byteArray);
Response.Flush();
}