How to show Binary image in Grid View in Asp.net

Hey, you can deal with the problem with HttpHandler (This is a simple demo to teach you how to read and write image field type into db):

(From Chinese CSDN:http://blog.csdn.net/rao3281/archive/2009/09/28/4604931.aspx)

               AutoGenerateColumns="False" >
   
                                 DataField="imagename" />
         
          
                        ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("ImageID")
                       %>'/> 
        
   
   

<asp:FileUpload ID="fuImage" runat="server" /><br />
<asp:TextBox ID="txtImageName" runat="server"/><br />
<asp:Button ID="btnUpload" runat="server" 
OnClick="btnUpload_Click" Text="Upload" />

In the web.config:

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;
AttachDbFilename=|DataDirectory|\Image.mdf;Integrated Security=True;
User Instance=True" providerName="System.Data.SqlClient"/>

protected void btnUpload_Click(object sender, EventArgs e)
{
    Stream imgStream = fuImage.PostedFile.InputStream;
    int imgLen = fuImage.PostedFile.ContentLength;
    string imgName = txtImageName.Text;
    byte[] imgBinaryData = new byte[imgLen];
    int n = imgStream.Read(imgBinaryData,0,imgLen);

    //use the web.config to store the connection string
    SqlConnection connection = new SqlConnection(ConfigurationManager.
    ConnectionStrings["connectionString"].ConnectionString);
    SqlCommand command = new SqlCommand(
     "INSERT INTO Image (imagename,image)
     VALUES ( @img_name, @img_data)", connection);

    SqlParameter param0 = new SqlParameter(
     "@img_name",SqlDbType.VarChar, 50);
    param0.Value = imgName;
    command.Parameters.Add(param0);

    SqlParameter param1 = new SqlParameter(
     "@img_data", SqlDbType.Image);
    param1.Value = imgBinaryData;
    command.Parameters.Add(param1);

    connection.Open();
    int numRowsAffected = command.ExecuteNonQuery();
    connection.Close();
}

public class ImageHandler : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        string imageid = context.Request.QueryString["ImID"];
        SqlConnection connection =
             new SqlConnection(System.Configuration.ConfigurationManager.
            ConnectionStrings["connectionString"].ConnectionString);
        connection.Open();
        SqlCommand command = new SqlCommand(
            "select Image from Image where ImageID=" + imageid,
             connection);
        SqlDataReader dr = command.ExecuteReader();
        if (dr.Read())            {                if (!(dr[0]is DBNull))                {                                context.Response.BinaryWrite((Byte[])dr[0]);                connection.Close();                context.Response.End();                }            }            }        public bool IsReusable        {            get            {                return false;            }        }

In the page_Load event:

SqlConnection connection = new SqlConnection(ConfigurationManager.
ConnectionStrings["connectionString"].ConnectionString);
SqlCommand command = new SqlCommand("SELECT imagename,ImageID
from [Image]", connection);
SqlDataAdapter ada = new SqlDataAdapter(command);       
DataTable dt = new DataTable();
ada.Fill(dt);
gvImages.DataSource = dt;
gvImages.DataBind();