Retrieve file and file name form SQL.

[tmeers]

Ok so a little backgroud, I have a image upload/retrieve app http://gettinlucky.dyndns.org/Shared/ that I use and have modifyed to fit my needs. (Now while I know most people shy away from storing images/binary data in a DB, it works for me.) It is in c# and it works great, except that when the file returns to the browser after being pulled out of the DB it will not return the file name. I had an app that did but it was useing access and was very slow.

Now while this example is in VB i'm fine with either.

Sub Page_Load(sender as object, e as EventArgs)
 
        Dim objConn As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("GstImg01").ConnectionString)
        Dim cmdText = "SELECT contenttype, filename, filedata, length FROM proj_file WHERE id='" & Request.QueryString("id") & "'"
        Dim objcmd As New SqlClient.SqlCommand(cmdText, objConn)
 
        objConn.Open()
        Dim objread As SqlClient.SqlDataReader = objcmd.ExecuteReader()
 
        Response.Clear()
        If objread.Read() Then
            Response.ContentType = objread("contenttype").ToString()
            Response.ContentType = objread("filename").ToCharArray()
            Response.ContentType = objread("length").ToString()
            Response.BinaryWrite(CType(objread("filedata"), Byte()))
        End If
 
        objConn.Close()
End Sub

How it is now will retun the file name being used to pull the file (ie get.aspx) when you try to save the image from the browser, however it does pull the correct content type (ie jpg). If I remove the second two "Response.ContentType" lines it will just pull the name not the extention (ie get). I have looked at my old app but for some reason cannot figure out what to change to get this to work.

Maybe some one out there has a solution?
Thanks
Tim