how to display image from sql table in gridview?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

hi i tried to display image from sql table to gridview but its not displaying this s my code to bind gridview with sql table records..

protected void Page_Load(object sender, EventArgs e)
   {
       SqlCommand cmd = new SqlCommand("Select * from tblImage",con);
       try
       {
           cmd.Connection.Open();

           SqlDataReader reader = cmd.ExecuteReader();
           gvwExample.DataSource = reader;
           gvwExample.DataBind();
           cmd.Connection.Close();
           cmd.Connection.Dispose();

       }
       catch (Exception ex)
       {
           lblStatus.Text = ex.Message;
       }

   }

and this is the design code

<pre><asp:GridView ID="gvwExample" runat="server" AutoGenerateColumns="false">
    
    <columns>
    <asp:BoundField DataField="iName" HeaderText="Name" />
    <asp:BoundField DataField="iAddress" HeaderText="Address" />
    <asp:TemplateField HeaderText="Photo">
                  <ItemTemplate>
                    <asp:Image ID="Image1" ImageUrl='<%#(Eval("iImage"))%>' runat="server" Width="200" Height="200"/>
                  </ItemTemplate>
                </asp:TemplateField>
    </columns>
   
    
    </asp:GridView>

please suggest..thanks and regards..

Posted 8-May-12 22:51pm

ythisbug

Add a Solution

2 solutions

Solution 3

XML

<asp:Repeater ID="repview" runat="server" >
                        <ItemTemplate>
                            <td class="bdr_top para_cbox bdr_lft">
                                <%#Eval("name")%>
                            </td>
                            <td align="center" class="bdr_lft bdr_top para_cbox ">
                                <img src="<%#Eval("iImage")%>" alt="" border="0" height="50" width="50" />
                            </td>
                            
                           
                            </tr>
                        </ItemTemplate>
                    </asp:Repeater>

Posted 8-May-12 23:13pm

binijoy

Comments

Manzoorali29 17-Jul-12 8:20am

sir i trid the above code for mysql database it work fine for url but not for the image field in mysql. my field datatype is longblob. plz help thanks

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad_Kulkarni · Accepted Answer · 2012-05-08T23:11:00

Please try following links, some good articles on CP will surely do some needful for you:

A simple guide for beginners, explaining one method of displaying images taken from a database on a GridView inside an ASP.NET web page:
Displaying Images from a Database in a GridView[^]

Display/Store and Retrieve Image Data from Database to Gridview, and also on mouse over: Display/Store and Retrieve Image Data from Database to Gridview, and also on Mouse Over[^]

Storing and Retrieving Images from SQL Server using Microsoft .NET[^]
Store or Save images in SQL Server[^]

Storing Images to Database and Retrieving to GridView[^]
Store or save images in SQL Server database using C#[^]
Storing images in SQL Server with RIA Services[^]
Display image in gridview[^]
Display Images In GridView From DataBase Asp.Net[^]
Display Images in GridView from Sql Server Database Table Using Asp.net C#[^]

GridView Examples for ASP.NET: Displaying Images in a GridView [^]

Save and retrieve images from database using asp.net[^]

how to display image from sql table in gridview?

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

how to display image from sql table in gridview?

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us