Retrieving images from access database

[nkpriya]

Retrieving images from access database:

I stored path of the images in access database. I am trying to display on my web page using gridview.

My select statement is:
select albumname,albumpic from albums.
Hyperlink is working fine, but not displaying image.Please help.

Here is the code.

<asp:TemplateField>

<ItemTemplate>
<asp:HyperLink ID="HyperLink1" NavigateUrl='<%#

Eval("albumname","album.aspx?albumname={0}") %>' runat="server">
<asp:Image ID="Image1" runat="server" ImageUrl='<%#

Eval("albumpic") %>' />
</asp:HyperLink>
</ItemTemplate>

</asp:TemplateField>

[wwb_99]

You are still dealing with a html image tag here. Meaning you need to create a http handler to stream the image out of the database with the appropriate content-type. You then set your HyperLink to get the image from the image handler.

Side note: Access does very badly storing binaries. Very, very bady. And that is on the desktop. For a web-facing application, you could see alot of scalability and database corruption issues.