BLOB Retrieve and Display problems

[Adam]

I have extensively searched for a solution. Below is my code that is
contained in an aspx. When my browser hits this aspx, I just get the
standard broken image picture. I know the data is the database is
correct because I have seen another employee retrieve it using Crystal
Reports. Can someone please tell me what I am doing wrong and offer a
suggestion to make this work? (This code does not generate errors, I
just can't the image to display.)
Adam
-----

Dim objSqlConnectio n As New SqlConnection
objSqlConnectio n.ConnectionStr ing =
Application("Co nnectionString" )

Dim id As Integer
id = 1956

Dim SQLcn As New
SqlConnection(o bjSqlConnection .ConnectionStri ng)

SQLcn.Open()

Dim cmd As New SqlCommand("sel ect ImageFile from
xcultivarimages where cultivarid=" & id, SQLcn)

Dim objDS As New DataSet
Dim clsImages As New Plantware.clsCu ltivarImages(SQ Lcn, objDS)

Dim imageArray As DataRow() =
objDS.Tables(0) .Select("Cultiv arid = " & id)
Dim imageRow As DataRow

For Each imageRow In imageArray
Response.Expire s = 0
Response.Buffer = True
Response.Clear( )
Response.Conten tType = "image/jpeg"
Response.Binary Write(imageRow( "ImageFile" ))
Next

[dave wanta]

you are trying to write out multiple images at the same time. The browser is
only expecting 1 image. Because you sent the data contained in multiple
images, it thinks that the 1 image is corrupt.

Try only writing out 1 image.

If you need to create a list of images, then you will need to create a html
page and link to each image separately.

hth,
Dave
www.aspNetEmail.com
"Adam" <ak************ **@yahoo.com> wrote in message
news:23******** *************** ***@posting.goo gle.com...

I have extensively searched for a solution. Below is my code that is
contained in an aspx. When my browser hits this aspx, I just get the
standard broken image picture. I know the data is the database is
correct because I have seen another employee retrieve it using Crystal
Reports. Can someone please tell me what I am doing wrong and offer a
suggestion to make this work? (This code does not generate errors, I
just can't the image to display.)
Adam
-----

Dim objSqlConnectio n As New SqlConnection
objSqlConnectio n.ConnectionStr ing =
Application("Co nnectionString" )

Dim id As Integer
id = 1956

Dim SQLcn As New
SqlConnection(o bjSqlConnection .ConnectionStri ng)

SQLcn.Open()

Dim cmd As New SqlCommand("sel ect ImageFile from
xcultivarimages where cultivarid=" & id, SQLcn)

Dim objDS As New DataSet
Dim clsImages As New Plantware.clsCu ltivarImages(SQ Lcn, objDS)

Dim imageArray As DataRow() =
objDS.Tables(0) .Select("Cultiv arid = " & id)
Dim imageRow As DataRow

For Each imageRow In imageArray
Response.Expire s = 0
Response.Buffer = True
Response.Clear( )
Response.Conten tType = "image/jpeg"
Response.Binary Write(imageRow( "ImageFile" ))
Next

[Adam]

Dave,
Thanks for your response. I tried displaying only one image, but it
still did not work. I then found out that the images were place into
the DB table using Access. From reading other posts, this leads me to
believe there is a header on the binary data. Is this true? If so,
how do I strip that header off?
Adam
"dave wanta" <no****@nospam. com> wrote in message news:<Oo******* *******@TK2MSFT NGP10.phx.gbl>. ..

you are trying to write out multiple images at the same time. The browser is
only expecting 1 image. Because you sent the data contained in multiple
images, it thinks that the 1 image is corrupt.

Try only writing out 1 image.

If you need to create a list of images, then you will need to create a html
page and link to each image separately.

hth,
Dave
www.aspNetEmail.com
"Adam" <ak************ **@yahoo.com> wrote in message
news:23******** *************** ***@posting.goo gle.com...

I have extensively searched for a solution. Below is my code that is
contained in an aspx. When my browser hits this aspx, I just get the
standard broken image picture. I know the data is the database is
correct because I have seen another employee retrieve it using Crystal
Reports. Can someone please tell me what I am doing wrong and offer a
suggestion to make this work? (This code does not generate errors, I
just can't the image to display.)
Adam
-----

Dim objSqlConnectio n As New SqlConnection
objSqlConnectio n.ConnectionStr ing =
Application("Co nnectionString" )

Dim id As Integer
id = 1956

Dim SQLcn As New
SqlConnection(o bjSqlConnection .ConnectionStri ng)

SQLcn.Open()

Dim cmd As New SqlCommand("sel ect ImageFile from
xcultivarimages where cultivarid=" & id, SQLcn)

Dim objDS As New DataSet
Dim clsImages As New Plantware.clsCu ltivarImages(SQ Lcn, objDS)

Dim imageArray As DataRow() =
objDS.Tables(0) .Select("Cultiv arid = " & id)
Dim imageRow As DataRow

For Each imageRow In imageArray
Response.Expire s = 0
Response.Buffer = True
Response.Clear( )
Response.Conten tType = "image/jpeg"
Response.Binary Write(imageRow( "ImageFile" ))
Next