Hi Guys

I'm trying to display an asp.net page which shows products with images relating to each product. I have a sql server table which stores all these products and at the moment the image name is stored not the actual image. I'm having trouble getting my image to display in a datagrid. I can create bound columns and display all my product info and I can create a template column that can display an image but I don't know how to display a different image for each product (ie I don't know how to retrieve the image name from the table and use that image name in the template column of my data grid).

All very confusing so any help would be much appreciated.

Thanks

Sorry.. I should give you the code I'm using at the moment:

<asp:TemplateColumn HeaderText="Image">
<ItemTemplate>
<asp:Image id="StockImage" runat="server" ImageUrl="images/fridge.jpg"></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>

Instead of hard coding the name of the image (images/fridge.jpg) in the ImageURL I tried this (below) but got error message.

<asp:TemplateColumn HeaderText="Image">
<ItemTemplate>
<asp:Image id="StockImage" runat="server" ImageUrl="images/" & '<%# DataBinder.Eval(Container.DataItem, "ImageName") %>'></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>