By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,587 Members | 1,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,587 IT Pros & Developers. It's quick & easy.

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

P: n/a
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;usrAction=Edt">
<HeaderStyle Font-Bold="True"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn Text="Delete"
DataNavigateUrlField="Employee_Id"
DataNavigateUrlFormatString="MaintCourseCode.aspx? parmCourseCode={0}&amp;usrAction=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>
Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <sa***@mississippi.org> wrote in message
news:24*************************@posting.google.co m...
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>

Nov 18 '05 #2

P: n/a
I am intrested in knowing how to get an image from a database field, I
was able to do it thru a link from the HTML. But how do I convert this
image (from a database field) to show it on a datagrid (so that HTML
can show it). Any sample code will be appreciated. Thanks.

Sahoo J

"bruce barker" <no***********@safeco.com> wrote in message news:<OP**************@tk2msftngp13.phx.gbl>...
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" <sa***@mississippi.org> wrote in message
news:24*************************@posting.google.co m...
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>

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.