How to get/load blob image using

Question

Im trying to load an image, field of longblob and I have a 1 row(id,design,name) data in my table. but when I click the button to show the image and it not showing it.

I have a GetImage.aspx to call my method

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    Try
        Using conn As New MySqlConnection(ConfigurationManager.ConnectionStrings("MySQLConnection").ToString())
            cmd = New MySqlCommand("SELECT design FROM mytable")
            Dim imageData As Byte() = DirectCast(cmd.ExecuteScalar(), Byte())
            conn.Open()
            Context.Response.Clear()
            Context.Response.ContentType = "image/jpeg"
            Context.Response.BinaryWrite(imageData)
            Context.Response.End()

        End Using

    Catch ex As Exception
    End Try
End Sub

And this is my control button to show the image from my default page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
    Image1.ImageUrl = "GetImage.aspx?"
End Sub

Please help I dont understand why my image is not showing

Joel Coehoorn · Accepted Answer · 2015-01-05 01:43:54Z

1

These lines are out of order:

Dim imageData As Byte() = DirectCast(cmd.ExecuteScalar(), Byte())
conn.Open()

You need to open the connection before you execute the command:

conn.Open()
Dim imageData As Byte() = DirectCast(cmd.ExecuteScalar(), Byte())

You also need to associate the connection with the command:

cmd = New MySqlCommand("SELECT design FROM mytable", conn)

edited Jan 5, 2015 at 1:43

answered Jan 5, 2015 at 0:59

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

PACMAN Over a year ago

I already tried. But it still not showing my image file. Di i have a problem to my button when i am using this? Image1.ImageUrl = "GetImage.aspx?". Thans

Joel Coehoorn Over a year ago

Do you see the image if you go directly to that url in your browser?

PACMAN Over a year ago

You mean if I run the GetImage? I run it but there is no image showing. But in my mysql database when I view it has a content image JPEG.

Joel Coehoorn Over a year ago

What happens if you remove the try/catch? You're swallowing the exception, and any information it might have about what went wrong.

PACMAN Over a year ago

yes! there is it gives me Connection must be valid and open. at this part "Dim imageData As Byte() = DirectCast(cmd.ExecuteScalar(), Byte())"

Collectives™ on Stack Overflow

How to get/load blob image using

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related