Displaying Blob Image From Db

I'm trying to retrieve an image that I have stored in a SQL Server db, and display it in an .aspx page. It's supposed to retrieve just one image, according to a unique key that's passed. However, when I view the page, nothing appears... just the Internet Explorer missing image placeholder.


I've tried code from several diff tutorials, and can't seem to get it to work.


I'm aware that some people think it's not a good idea to store images in a db, but I have to in this case, since the requirements for this project are that the images are stored in the database. I already know how to store references to file paths of images located in a server folder. I've just never done it this way... storing the whole images in the database. The table has 3 columns, one for the id, "FileType" stores the image type, and the "ImageBinary" is the image itself.


If anyone can shine some light on why my code doesn't display anything, I'd greatly appreciated your help.








Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load





Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("strConn"))


Response.Write("Page Loaded") 'This is just for testing to see if the page loads at all


Dim myCommand As New SqlCommand("Select * from UserImages WHERE id=1234", myConnection)


Try


myConnection.Open()


Dim DR As SqlDataReader


DR = myCommand.ExecuteReader(CommandBehavior.CloseConnection)


If DR.Read() Then


Response.ContentType = DR.Item("FileType")


Response.BinaryWrite(DR("ImageBinary"))


Else


Response.Write("no image found")


End If


myConnection.Close()


Response.Write("<br>Image successfully retrieved!")


Catch SQLexc As SqlException


Response.Write("Read Failed : " & SQLexc.ToString())


End Try


End Sub