Re: how to show an Image field from a SQL Server table field to a aspx page

From: bruce barker (nospam_brubar_at_safeco.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 10:11:06 -0700

IE does not support inline images. your table should have a url to the
image, then you write an aspx page that display the image. a quick google of
this newgroup will show lots of examples.

-- bruce (sqlwork.com)

"J Sahoo" <sahoo@mississippi.org> wrote in message
news:248795d.0407060843.6d0f9abd@posting.google.com...
> Hi,
> I have a browse page where I am showing few fields from my SQL Server
> table. One of the field is Image type, all the fields are bound to a
> single table.
>
> I want to show the image from the table on this browse along with the
> other fields. Here is the code what I have from the HTML view, I am
> using a datagrid to show the result. It does not show the image rather
> it shows "System.Byte[] " on the output. I did not have any code
> behind page logic for this image field (mypicture).
>
> Thank you.
>
> Sahoo J
>
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
> <asp:datagrid id=DataGrid1 runat="server" ForeColor="Black"
> Width="520px" BorderColor="Tan" Height="358px" DataSource="<%# DsPict1
> %>" DataMember="SahooPhoneTbl" AutoGenerateColumns="False"
> BorderWidth="1px" BackColor="LightGoldenrodYellow" CellPadding="2"
> GridLines="None">
> <SelectedItemStyle ForeColor="GhostWhite"
> BackColor="DarkSlateBlue"></SelectedItemStyle>
> <AlternatingItemStyle
> BackColor="PaleGoldenrod"></AlternatingItemStyle>
> <HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle>
> <FooterStyle BackColor="Tan"></FooterStyle>
> <Columns>
> <asp:HyperLinkColumn Text="Edit"
> DataNavigateUrlField="Employee_Id"
>
DataNavigateUrlFormatString="MaintCourseCode.aspx?parmCourseCode={0}&amp;usr
Action=Edt">
> <HeaderStyle Font-Bold="True"></HeaderStyle>
> </asp:HyperLinkColumn>
> <asp:HyperLinkColumn Text="Delete"
> DataNavigateUrlField="Employee_Id"
>
DataNavigateUrlFormatString="MaintCourseCode.aspx?parmCourseCode={0}&amp;usr
Action=Del">
> <HeaderStyle Font-Bold="True"></HeaderStyle>
> </asp:HyperLinkColumn>
> <asp:TemplateColumn HeaderText="Status">
> <HeaderStyle Font-Bold="True"></HeaderStyle>
> <ItemStyle HorizontalAlign="Left"></ItemStyle>
> <ItemTemplate>
> <div align="center">
> <IMG SRC='<%# Container.DataItem("mypicture") %>'
> Border="0">
> <br>
> <%# (Container.DataItem("mypicture")) %>
> </div>
> </ItemTemplate>
> </asp:TemplateColumn>
> <asp:BoundColumn DataField="Phone" SortExpression="Phone"
> HeaderText="Phone"></asp:BoundColumn>
> <asp:BoundColumn DataField="Name" SortExpression="Name"
> HeaderText="Name"></asp:BoundColumn>
> <asp:BoundColumn DataField="Employee_Id"
> SortExpression="Employee_Id"
> HeaderText="Employee_Id"></asp:BoundColumn>
> </Columns>
> <PagerStyle HorizontalAlign="Center"
> ForeColor="DarkSlateBlue" BackColor="PaleGoldenrod"></PagerStyle>
> </asp:datagrid></div>