Displaying an image from the database.

[mike55]

Hi all

I am trying to display images that are stored in the database on my web page. From what I have read, I should get the images and display them on one page, and then link my image control to the page i.e.
Photo.aspx would contain the code for downloading and displaying my image.

 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Try
            OpenConnection()
            sqlCmd = New SqlCommand
            sqlCmd.Connection = conSql
            sqlCmd.CommandText = "SELECT Picture, ImageType FROM myImages WHERE Identification = " & Request.QueryString("ID").ToString
            Dim myDataReader As SqlDataReader
            myDataReader = sqlCmd.ExecuteReader
            Do While (myDataReader.Read())
                Response.ContentType = myDataReader.Item("ImageType")
                Response.BinaryWrite(myDataReader.Item("Picture"))
            Loop
            myDataReader.Close()
            Response.Redirect("default.aspx", False)
        Catch ex As Exception
        Finally
            CloseConnection()
        End Try
    End Sub

While the page default.aspx would have an image control imgPicture, whose imageUrl is set to the page Photo.aspx. The only problem is that I cannot get/dont know how to get the page_load event to execute.

Mike55

 

[mike55]

Ok, after a lot of cursing and swearing at the computer and the world in general, I sorted out a solution. On the default.aspx add an html Image control, set its runat property to "server", set the id and name property to "image2" (you can use anything you like). In your code, when you want to display a picture for a particular person, call the following line of code:

image2.src = "photo.aspx?id=" & me.txtImage.text

where txtImage is a text box where you specify the id number of the picture you wish to display.

Mike55.