Viewing a SQL image type

[tassflint]

Hello all,

I am receiving an error when I try to view an image that I have stored in my SQL database. I have used the following code :

cmd.Connection = conn
        cmd.CommandText = "Select filetype, img from ScanInfo"
        
        Try
            conn.Open()
            read = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
            Do While read.Read()
                Response.ContentType = read.Item("filetype")
                Response.BinaryWrite(read.Item("img"))
            Loop
            'stream.Write(pic, 0, pic.Length)
            'spic = New System.Drawing.Bitmap(stream)
            'Response.ContentType = "image/jpg"
            'spic.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg)
        Catch ex As Exception
            txtTester.Text = ex.ToString
        Finally
            conn.Close()
            stream.Close()
        End Try

When the page finally opens it tells me :

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


--------------------------------------------------------------------------------

An invalid character was found in text content. Error processing resource


I am not sure how to get this resolved. The section of my code that is commented out does not work at all, which is why I switched to the other way.

Thanks in advance,

Brian

 

[tassflint]

Hello all,

I figured out what was going wrong with my previous code. I had the wrong content type going in because the picture I choose was not of the same type as I had said it was.

Now I am having a different problem. The binarywriter does not produce the image, it just writes out the binary coding for the image. So I created a new page that has an image control in it and set the imageurl to the page with the binarywriter on it. The image still does not show up, does anyone have any ideas on why this is not working?



Thanks in advance,

Brian

 

[macleod1021]

I worked with something similar a long time ago. Check out this doc from MS

http://support.microsoft.com/?kbid=317670

Theres also a bunch of sites that offer help. Google "BLOB Database Entry" and you should find a lot of entries.