Hi all,

I have a little problem to display a image( gif file) in my webpage.
The images are stored in sqlserver 2000 table and datatype as sqlserver.image ( actualy is byte[]). When I retrieve records from database, the image colum is return as a stream of data. On my webpage, I have the following

<asp:TemplateColumn HeaderText="Picture">
<ItemTemplate>
<img id=myImage border=0 runat="server" width=30 height=30
  src="<%#Databinder.Eval(Container.DataItem,"pictur e")%>" />
</ItemTemplate>

Insteads show the images, the column shows "System.Byte[]". I know src is not the right property in this case but I dont know how to fix it right now. Please help me to fix the problem.

Thanks



</asp:TemplateColumn>

You need to convert the binary to image using Response.BinaryWrite method.
Check the below article which explains how to retrieve the binary image from database and dispaly in DataGrid.Hope this will be useful..
http://www.dotnetbips.com/displayarticle.aspx?id=101

Since I retrieved pictures back form database directly, the codes below just display "System.byte[]" insteads of picture. How can I use Response.binaryWrite() in this case. I have tried

<%
Response.binaryWrite(Databinder.Eval(Container.Dat aItem,"picture"))
%>

but it gave me error: Name 'Container' is not declared. What does '#' in front Databinder means? How to fix this problem?

Thanks


*******************************************
This codes segment show "system.byte[]"

<asp:TemplateColumn HeaderText="Picture">
<ItemTemplate>
   <%#Databinder.Eval(Container.DataItem,"picture") %>
</ItemTemplate>
</asp:TemplateColumn>

*************************************************8

<%#> denotes DataBind expression block.We cannot use server side scripting in this block.And Container will be used in Databing Statements only.It denotes the parent control.