«

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>

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" <> wrote in message
news: 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>

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" <> wrote in message news:<>...
> 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" <> wrote in message
> news: 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>

[naikpalak]

Was anyone able to fix this. I am having similar issues with my windows app. I am using Datagridbuttoncolumnstyles to display an edit button in one of the columns in my datagrid. Any time I insert rows from my database and bind it to this datagird, i get System.Byte[] as text on my button instead i would like to have "Edit" as my text. I have the header text as:
buttonColStyle.HeaderText = _dataSet.Tables["OPAServices"].Columns[i].ColumnName;
and it shows "Edit" but not on my display???