is it possible to display image in gridview

[imranabdulaziz]

Dear All,

I am using asp.net2.0, sql 2005
I am storing Image url in database. through that url i would like to show images in gridview
I want to know is it possible to show images in gridview.
Please guide me or give me some useful link.
Thanks

[gwtech]

First off store your pics in a folder!
Just save the name in the db. Saving pics to the db can bloat it quickly.
[please refrain from advertising your services on this forum]

This code is the Master Detail with photo for my system.

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="PictureID"
DataSourceID="SqlDataSource1" Height="50px" Width="885px" CellPadding="4" ForeColor="#333333" GridLines="None">
<Fields>
<asp:BoundField DataField="PictureID" HeaderText="PictureID" InsertVisible="False"
ReadOnly="True" SortExpression="PictureID" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" />
<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
<asp:ImageField DataImageUrlField="PictureURL" HeaderText="Photo">
</asp:ImageField>
<asp:TemplateField HeaderText="Dog Info" SortExpression="DogInfo">
<EditItemTemplate>
<asp:TextBox ID="DogInfo" runat="server" Rows="8" Text='<%# Bind("DogInfo") %>' TextMode="MultiLine"
Width="456px"></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DogInfo") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemStyle Width="600px" />
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("DogInfo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="URLSource" HeaderText="Link" SortExpression="URLSource" />
<asp:BoundField DataField="DateUploaded" HeaderText="Created On" ReadOnly="True"
SortExpression="DateUploaded" />
<asp:BoundField DataField="Contact" HeaderText="Contact" SortExpression="Contact" />
<asp:BoundField DataField="UEmail" HeaderText="Contact Email" SortExpression="UEmail" />
<asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
<asp:BoundField DataField="FileSize" HeaderText="FileSize" ReadOnly="True" SortExpression="FileSize" />
<asp:BoundField DataField="Updated" HeaderText="Updated" ReadOnly="True" SortExpression="Updated" />
<asp:CommandField ShowEditButton="True" ButtonType="Button" />
</Fields>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<CommandRowStyle BackColor="#FFFFC0" Font-Bold="True" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<FieldHeaderStyle BackColor="#FFFF99" Font-Bold="True" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:DetailsView><br />

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="PictureID" DataSourceID="PicturesDataSource"
Width="885px" PageSize="4">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" ButtonType="Button" />
<asp:BoundField DataField="PictureID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="PictureID" />
<asp:BoundField DataField="Name" HeaderText="Dog's Name" SortExpression="Name" />
<asp:BoundField DataField="DogInfo" HeaderText="Dog's Info" SortExpression="DogInfo" />
<asp:ImageField DataImageUrlField="PictureURL" HeaderText="Photo">
</asp:ImageField>
<asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" />
<asp:BoundField DataField="Contact" HeaderText="Contact" SortExpression="Contact" />
<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
<asp:BoundField DataField="Updated" HeaderText="Updated (Date)" SortExpression="Updated" />
</Columns>
</asp:GridView>